Importing tables separately

[waterbender]

Hi,

I am upgrading from v1.3.7 to v1.3.9 and was wondering if the following steps would work. Please advise. Thanks.

Plan A:
1. Backup only the standard core zen cart tables (without third party modules) in the live shop database.
2. Import this database into a new empty database.
3. Upgrade the standard core zen cart tables in the new database to the latest version.
4. Install the latest third party modules in the new database.
5. Backup the new database (both the standard core zen cart tables and third party module tables).
6. Repeat step 1 to include new orders.
7. Import this latest live shop database into the new database to combine everything together.

Plan B (if A doesn't work):
1. Backup only the standard core zen cart tables (without third party modules) in the live shop database.
2. Import this database into a new empty database.
3. Upgrade the standard core zen cart tables in the new database to the latest version.
4. Install the latest third party modules in the new database.
5. Backup only the latest third party module tables (the standard core zen cart tables) in the new database.
6. Repeat step 1 to include new orders.
7. Empty the new database and import the latest live shop database.
8. Repeat step 3.
9. Import the latest third party module tables.

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