« nokia web tablet
blast from the past »

mysqldump of remote database to local machine command

example

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

This entry was posted on Friday, December 23rd, 2005 at 10:51 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

2 Responses to “mysqldump of remote database to local machine command”

  1. Philip Thompson Says:
    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

  2. Lenni Says:
    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

Leave a Reply