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