Web Hosting Talk







View Full Version : Merging 2 databases into one.


Salvatore
05-26-2004, 02:14 AM
I would like to merge 2 modernbill billing databases for 2 different companies into one database centrally located on a neutral domain for all future billing. Can someone please explain to me how I can merge these 2 mysql databases?

Thank you and I am not too profitient in phpmyadmin so a good description would be highly appreciated. Thank you very much

Salvatore
05-26-2004, 02:40 PM
Nobody knows how to do this?

Thank you

alex-info
05-26-2004, 02:45 PM
Maybe try the modernbill forums ? They may already have script or tricks to do this...

Salvatore
05-26-2004, 02:47 PM
I have always had a much better response from webhostingtalk, Thank you

blockcipher
05-26-2004, 11:47 PM
Should not be a problem if you set prefixes. For example

<companyname1_table>
<companyname2_table>

You would have to contact ModernBill though on how to take your current tables and put them into something like that. But then again their software might not suppor that. MB is the best resource for something like that, not WHT.

I hope this helps some?