Which MYSQL Tables to replace and which to leave alone?

[southwestcrm]

Two seperate intallations 1) local 2) Internet-based. I wanted to replace the Internet DB with the contents of my local DB. I did this using phpMYAdmin. I deleted ALL tables from the Internet DB and Imported a backup of my Local DB. this worked so that the Accounts/Contacts etc were now available on my Internet copy.

However, I had previously installed several modules from sugarforge on the Internet copy and when I go to module uploader they are no longer listed. I presume I overwrote a DB file which contains this history.

My question is, does anyone know where I can get a list of DB files I can overwrite and list of ones I should leave alone?
Did I do the wrong thing?

Both DB were 4.5.1.d MySQL databases running Apache

[kuske]

Did I do the wrong thing?

In my humble opinion I would say YES.

First of all I would propose to restore your internet DB - do you have a backup?

Then install mysqltools, including mysqladmin which will help to understand the database more quickly then phpmayadmin does.

Now you should take a close look to the tables and their content in both databases (local and internet).

I good idea could be to use MSACCESS with ODBC to link both databases in one ACCESS database, so you can open two tables at the same time to look on them. Make a checklist! Take one table after the over. Do you have custom fields? Then you need _cstm tables to be filled.

All in all a job for 1-2 days.

Good luck
hk