MySQL Dump using query

Question

I want to dump my DB with a click on a button in my C#.Net App. I thought about using

Process.Start(@"mysqldump", @"-u root -p mydb > dump.sql");

but this command opens a command prompt asking for the MySQL user password.

how can I avoid this?

Pascal MARTIN · Accepted Answer · 2011-08-06 13:39:30Z

1

Instead of this command :

mysql -u root -p mydb > dump.sql

Try using this, passing the password in the command, so mysqldump doesn't ask for it :

mysqldump -u root --password=YOUR_PASSWORD mydb > dump.sql

answered Aug 6, 2011 at 13:39

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1