Thursday, July 21, 2011

MySQL Dump Database

Dump:

1. mysqldump -u root -p database_name > db_backup.sql

2. somehow get db_backup.sql to the machine where you want to dump, and make sure you can see db_backup.sql from ls

3. mysql -u root -p

4. use database_you_want_to_dump_name

5. source db_backup.sql

6. show tables;

Yay!

source

No comments:

Post a Comment