Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Merge nubuilder databases

Locked
ruiascensao
Posts: 177
Joined: Tue Nov 15, 2011 2:24 pm

Merge nubuilder databases

Unread post by ruiascensao »

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
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: Merge nubuilder databases

Unread post by massiws »

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
ruiascensao
Posts: 177
Joined: Tue Nov 15, 2011 2:24 pm

Re: Merge nubuilder databases

Unread post by ruiascensao »

Hi massiws,

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

Thanks!!
BR
Rui
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: Merge nubuilder databases

Unread post by massiws »

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.
Locked