Labels

Friday, September 23, 2016

Mysql dump and restore tables

To dump tables t1, t2, ... from mysql dababase db:
mysqldump -u USERNAME -p db t1 t2 ... > tables.sql

To restore the tables:
mysql -u USERNAME -p db < tables.sql

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)