Page 1 of 1

table dump from mySQL..question

Posted: Fri Jan 03, 2003 1:12 am
by rxsid
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!