Get a backup from MySQL

Get a backup from MySQL

Backup from Local MySQL

mysqldump dbname --result-file=E:/backup.sql --user=root --host=localhost --password

Backup from Remote MySQL

mysqldump dbname --result-file=E:/emote.sql --user=root --host=192.168.11.132 --port=3306 --password