Backing up a remote mySQL database

To backup a mySQL database from a remote machine to your home (linux) machine, use the following:

mysqldump –-host=the.remotedatabase.com -u yourusername -pyourpassword yourdatabasename > /Users/rick/backups/foo.sql

From http://www.rickhurst.co.uk/2005/12/23/mysqldump-of-remote-database-to-lo...

You have viewed this page 1 times