Wednesday, June 13, 2007

How to export data from one database and import into another.

mysqldump -u root -p myapp_staging some_table > mytable.sql

and then

mysql -u root -p myapp_acceptance < mytable.sql

1 comment:

  1. Anonymous3:29 PM

    Usage: mysqldump [OPTIONS] database [tables]

    Should have DB name after 'mysqldump'



    -"qa"

    ReplyDelete