MySQL command to just copy tables?

[Kaelon]

Here's my situation: I have a huge (1.3 million post) forum, and I am planning to move it to a new database (same server) where I will build a new site around it.

Is there a specific MySQL command to copy tables and their contents from one MySQL database to another?

I usually do a mysqldump to get my data out into a .SQL file, and then re-import that .SQL file into a new database. However, I really just want to get specific tables out and into another database. Is there a database-to-database copy that I can do of my tables, skipping the mysqldump .SQL file process altogether?

Thanks!

[Andreas]

If you have physical access to the files (.myi, .myd, .frm) you could just copy them.

Otherweise, create teh table structure and do an
INSERT INTO target (SELECT * FROM source)

[Kaelon]

Originally Posted by Andreas

If you have physical access to the files (.myi, .myd, .frm) you could just copy them.

Otherweise, create teh table structure and do an
INSERT INTO target (SELECT * FROM source)

Is this sustainable for a large forum like mine?