Use MySQL to dump databases

Often times you will need to dump your MySQL database from one machine to another. Sometimes you can use utilities like PHPMyAdmin, but it’s always useful to know how to dump your database’s contents manually.

add3-imac:~ jon$ mysqldump -u username -p databasename >/tmp/databasename.sql

Tags:

This entry was posted on Monday, March 3rd, 2008 at 4:53 pm and is filed under technology. You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

5 comments

  3. Anonymous
    April 10, 2009 at 6:17 pm

    Great post, really help me alot. Thanks.

    http://golfman.the-mnm.info

  4. Anonymous
    April 10, 2009 at 6:18 pm

    Great post, really help me alot. Thanks.

    http://golfman.the-mnm.info

Leave a comment