Importing tables separately

[DrByte]

Neither is advisable.

Why not just follow the instructions provided?
You should NOT be picking-and-choosing which tables to move. They all work together. Separating them simply subjects you to corrupted data and needless wasted downtime.

[waterbender]

Hi DrByte

Thanks for your advise. I suspected both would not work but just wanted to confirm. I came up with those ideas because the instructions I used seem to take forever and made me be stuck in a loop. Here is what I have been doing:

Backup and load all the tables from the live shop to a new empty database. Upgrade all the tables to the latest version. Reinstall/upgrade all the third party modules that are needed and uninstall those that are not needed. However not all the third party modules have an uninstall sql file (I am stuck here). By the time I finished doing all this, new orders came in. I drop all the tables in the new database and load all the tables from the live shop again. When I do this, all the third party modules will need to be reinstalled/upgraded/removed again (this is also a pain).

A few questions please:
1. Any idea how I can do the above better?
2. I want to remove the third party modules that don't have an uninstall sql file. Would you be able to help me make the uninstall sql if I show you their install sql files?
3. Out of curiosity, I have this idea. Can you tell me if this would work?
- Set up 2 new empty databases. Backup and load all the tables from the live shop to the first new empty database. Upgrade all the tables to the latest version. Reinstall/upgrade all the third party modules that are needed and uninstall those that are not needed. Do another new backup of the live shop and load it into the second new empty database. Upgrade these tables to the latest version. Do a backup of the second database and then load it into the first database. Would everything combine well without problems?

Thanks again.