Invoking mysqldump from script without password prompt

Question

I need to execute a cmd command in Visual Basic. It's not difficult but i need to give a argument while the external Programm runs.

F:\mysql-5.7.13-winx64\bin\mysqldump.exe -h <ip> -u <user> -p <database> > abcd.sql

But after that is executed, the programm will ask for a password. So how can i do that?

Greetings, Dominic

Can you post your method of calling this in Visual Basic? – Jake Jul 27 '16 at 17:47 — Jake, Jul 27 '16 at 17:47

napuzba · Accepted Answer · 2016-07-27T18:32:22.663

6

You can provide a password at command line (not secure):

mysqldump.exe -h <ip> -u <user> --password="my_password" <database> > abcd.sql

You can also use Mysql options file. Create my.cnf with credentials details:

[mysqldump]
host="my_host"
user="my_user"
password="my_password"

And provide it to mysqldump

mysqldump.exe <database> --defaults-extra-file=my.cnf > abcd.sql

edited Jul 27 '16 at 18:32

answered Jul 27 '16 at 17:51

napuzba

1 Answers1