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.sqlmysqladmin -u username -p create new_databasemysql -u username -p new_database < db_test.sqlBut 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 ?
dump out some tables of the database
linux;mysql;database
You'll find what you need directly in the mysqldump documentation:mysqldump -u username -p db_test table1 table2 ... > db_test.sqlLoad the dump the same way as if it was a full database dump.