The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
MySQL command to just copy tables?
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! |
#2
|
||||
|
||||
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) |
#3
|
||||
|
||||
Is this sustainable for a large forum like mine?
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|