mysqldump of remote database to local machine command
example
#mysqldump –host=the.remotedatabase.com -u yourusername -p yourdatabasename > /Users/rick/backups/foo.sql
example
#mysqldump –host=the.remotedatabase.com -u yourusername -p yourdatabasename > /Users/rick/backups/foo.sql
October 31st, 2008 at 6:21 pm
Hi Rick,
You left out a ‘-’ before the host. The correct syntax is:
#mysqldump –-host=the.remotedatabase.com -u yourusername -p yourdatabasename > /Users/rick/backups/foo.sql
August 22nd, 2009 at 11:00 am
@Philip: I have copied your command to my terminal and it ends up with the wrong sort of hyphen. I think it should be:
#mysqldump –host=the.remotedatabase.com -u yourusername -p yourdatabasename > /Users/rick/backups/foo.sql