vb.org Archive - Databases

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

- General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)

- - Databases (https://vborg.vbsupport.ru/showthread.php?t=161455)

ChU v2

10-29-2007 10:15 PM

Databases

How exactly do you merge two databases? I uploaded one and uploaded the other and the first one gets overwritten it seems, but the tables are still there. But the forum has not changed.

Eikinskjaldi

10-29-2007 10:47 PM

Quote:

Originally Posted by ChU v2 (Post 1371518)

How exactly do you merge two databases? I uploaded one and uploaded the other and the first one gets overwritten it seems, but the tables are still there. But the forum has not changed.

You are going to have to give us a bit more information about what you want to do, and how you have been going about it. what does "uploaded" mean? import from mysqldump? import from mysqlhotcopy? a custom merge script?

ChU v2

10-29-2007 11:35 PM

imported into phpmyadmin using the sql databases after the 2 have been gzipped.

Marco van Herwaarden

10-30-2007 05:49 AM

If you restore a second backup into the same database, then yes it will overwrite the first one.

If you want to merge them, you will need to restore them into 2 seperate databases and use ImpEx to merge them.

ChU v2

10-30-2007 08:34 PM

How would I go about doing that exactly?

Thanks for the help.

Marco van Herwaarden

10-31-2007 08:18 AM

Appendix 5: ImpEx Import System

ChU v2

11-01-2007 03:21 AM

Thank you Marco.

All times are GMT. The time now is 05:50 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01000 seconds Memory Usage 1,718KB 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 (7)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: