Backing up a MySQL database remotely to a local machine with a shell command -


i have remote machine several mysql databases automatically local machine. there shell command can execute local machine this? remote mysqldump. help?

mysqldump --all-databases --routines -h <ip-address> -u <user> -p > dump.sql 

if want run automatically have write password next -p parameter.


Comments