table dump quesiton

[4rxsid]

Hi all,

I have recently moved from a host that provided only 1 mySQL db, to a host that allows multiple db's.

1. How do I dump a table, or tables from the single db...into a new db(s)?

I've used this before (to dump the entire db):

mysqldump -h mysite.com -q mysite_dbname > db_dump.sql -pmysitepassword

but I want to extract specific table(s) from the origian db and move them into newly created db's of their own on the new server.

Thanks!

[IceD]

There are two wayts to do this:
1. Dump full database and create several sql files manually (using VIM e.g.)
2. Create dumping script

[danielsampson]

This might be too late but I just figured it out myself.

mysqldump dbname table1 table2 table3 > dumpfile.sql

The trick is having the table names separated by a space.

Hope this helps future endeavors.