Spread the love

You can create mysqldump like this:

mysqldump --defaults-extra-file=/path/to/config.cnfCode language: JavaScript (javascript)

create config.cnf:

[client]
user = whatever
password = whatever
host = whatever

Now lets backup a database

mysqldump --defaults-extra-file=/path/to/config.cnf database > /root/export.sqlCode language: JavaScript (javascript)

Leave a Reply