mysqldump - How to use MySQL dump from a remote machine

Question

How can I backup a mysql database which is running on a remote server, I need to store the back up file in the local pc.

Answer 1

Try it with Mysqldump

#mysqldump --host=the.remotedatabase.com -u yourusername -p yourdatabasename > /User/backups/adump.sql