mysqldump of remote database to local machine command

example

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

One Response to “mysqldump of remote database to local machine command”

  1. Philip Thompson Says:

    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

Leave a Reply