Merge nubuilder databases

Merge nubuilder databases

Postby ruiascensao » Fri May 10, 2013 7:15 pm

Hi,

I have 2 databases in the same installation of nuBuilder and I need to merge so I could have just one website.
Is this possible to do in a easy way?

Thank you.
BR
Rui
ruiascensao
 
Posts: 177
Joined: Tue Nov 15, 2011 10:54 pm

Re: Merge nubuilder databases

Postby massiws » Thu May 16, 2013 2:28 pm

Rui,
have all your tables in two databases different names?
If yes, you can merge them with phpmyadmin:
- backup your DBs;
- go in first DB with phpmyadmin > Export > select all tables > save the dump on your desktop
- go in second DB with phpmyadmin > Import > select the previous dump file

Now you should enter all tables with the parameter of second DB, maybe, you have to fix values in System Setup.

Hope this helps,
Max
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: Merge nubuilder databases

Postby ruiascensao » Thu May 16, 2013 5:05 pm

Hi massiws,

Tables are different.
But what to do with nuBuilder tables that are the same in both installations? Just merge?

Thanks!!
BR
Rui
ruiascensao
 
Posts: 177
Joined: Tue Nov 15, 2011 10:54 pm

Re: Merge nubuilder databases

Postby massiws » Thu May 16, 2013 11:09 pm

If you want forms, objects, users, ect. in one database, I think merge contents is the only way (you may exclude tables zzsys_variable, zzsys_user_log, zzsys_trap, zzsys_report_log).
The only thing to pay attention is the zzsys_setup table, that in both installations may have one record with id=1.
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy


Return to Installation