Software Development
Pages
(Move to ...)
Home
About
Contact
▼
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:
Anonymous
3:29 PM
Usage: mysqldump [OPTIONS] database [tables]
Should have DB name after 'mysqldump'
-"qa"
Reply
Delete
Replies
Reply
Add comment
Load more...
‹
›
Home
View web version
Usage: mysqldump [OPTIONS] database [tables]
ReplyDeleteShould have DB name after 'mysqldump'
-"qa"