I am using MySQL v5.1 on Ubuntu machine.

I have a database named db_test which contain tables like cars, customers, departments, prices , and so on.

I know I can use the following commands to dump out the db_test database and dump the database back into a new database in following way:

mysqldump -u username -p -v db_test > db_test.sql
mysqladmin -u username -p create new_database
mysql -u username -p new_database < db_test.sql

But for my new_database , I only needs some tables from db_test database, not all the tables.

So, How can I dump out some tables from db_test database and dump these tables back to my new_database ?


You'll find what you need directly in the mysqldump documentation:

mysqldump -u username -p db_test table1 table2 ... > db_test.sql

Load the dump the same way as if it was a full database dump.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.