table dump from mySQL..question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rxsid
Forum Commoner
Posts: 82
Joined: Thu Aug 29, 2002 12:04 am

table dump from mySQL..question

Post 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!
Post Reply