vb.org Archive - MySQL command to just copy tables?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - MySQL command to just copy tables? (https://vborg.vbsupport.ru/showthread.php?t=154634)

Kaelon

08-08-2007 10:45 AM

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!

Andreas

08-08-2007 10:53 AM

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

08-08-2007 11:39 AM

Quote:

Originally Posted by Andreas (Post 1312631)

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?

All times are GMT. The time now is 02:25 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01353 seconds Memory Usage 1,709KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: