Page 1 of 1

Merge nubuilder databases

Posted: Fri May 10, 2013 11:45 am
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.

Re: Merge nubuilder databases

Posted: Thu May 16, 2013 6:58 am
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

Re: Merge nubuilder databases

Posted: Thu May 16, 2013 9:35 am
by ruiascensao
Hi massiws,

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

Thanks!!

Re: Merge nubuilder databases

Posted: Thu May 16, 2013 3:39 pm
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.