Strategies for upgrading database with numerous add-ons?

[ilikemike]

@DrByte Thanks for your advice, which confirms what I discovered after installing barebone 1.3.9h and then discovered how daunting it would be to re-apply all the customization work I did so far (some of the add-ons are inter-mingled with the visuals the template).

So, if I understand your summary correctly, it is easier, less time-consuming and perhaps safer, to upgrade an existing copy (and then tweak it) than starting from fresh.

Is this correct?

And a follow up question regarding this step:

Once ready, go to the live site, set down for maintenance, apply all the PHP file changes, run zc_install, apply all addon database changes, admin settings changes, tweaks etc, then test and turn off down for maintenance to go live

Why re-apply all PHP changes, if I already have a copy that is "tested tested tested"? Wouldn't it be simpler to copy the tested copy over to the operational site?

[pagypsy]

on a similar note, i was under the impression that it would be easier and safer to do a clean install, rather than comparing the thousands of different files in winmerge. thousands of different files is what i have, thus the consideration of a clean install. i have begun the upgrade process several times and then deleted and started over. after importing the database to the clean install, mostly everything is there except for my template and cosmetic changes. the add-ons come along too, but of course are not working until you reinstall each addon. wouldn't a clean install be less time consuming than an upgrade where thousands of files need to be compared side by side? if so, the only question i have, and which stops me from completing the upgrade/clean install, is how do you uninstall the add-ons (to re-install new versions of each) from the database after it's been imported?

i've read the upgrade instructions several times. i've tried it several times. but i stop when it comes to comparing all the files.

[rstevenson]

The clean install approach might be the best route if you're modifying your site as well as upgrading it. I did that with my retail site for just that reason.

As for "how do you uninstall the add-ons (to re-install new versions of each) from the database after it's been imported?" A well written add-on that needs to modify the database will have both an install.sql file and an uninstall.sql file. So you'd run the uninstall.sql file. If you just mean that there are settings in admin that you'd like to somehow unset, that's not so easy. But I wouldn't worry about it either. You're going to be spending lots of time in the admin getting things setup, so you'll make your adjustments there as you go. I worried about the same things when I was hemming and hawing about the upgrade, but once I started it, everything went smoothly.

Rob

[DrByte]

Why re-apply all PHP changes, if I already have a copy that is "tested tested tested"? Wouldn't it be simpler to copy the tested copy over to the operational site?

How is that different from "re-applying all PHP changes"?

[DrByte]

Folks, everyone wants a shortcut. I strongly advise against shortcuts. Only take shortcuts when you have a SOLID understanding of EXACTLY what you're doing.
And, frankly, if you're asking how to shortcut, then you're exposing the fact that you probably shouldn't be taking shortcuts. No offense intended in that statement. Just observations from lots of experience.

The main PURPOSE of using WinMerge is to identify for YOURSELF all the customizations you need to re-do in the new version files before they'll be ready to use on your live site. That's explained in the Tutorial on the topic: https://www.zen-cart.com/tutorials/index.php?article=98 If you look at it from that angle you're just quickly rebuilding your site from scratch, but using WinMerge to very quickly show you what you'd previously customized so that you can redo it again in a few minutes instead of taking much longer.

As for uninstalling old mods, as Rob says, just uninstall them the way you'd uninstall any mod even if you were *not* doing an upgrade. It's the same procedure either way.

Whatever you do, MAKE SURE you DO NOT directly upgrade your LIVE site until you've TESTED it completely on a test site. ONLY THEN is it appropriate to apply all the changes to your live site. Again, follow the official upgrade instructions as mentioned at https://www.zen-cart.com/tutorials/index.php?article=98 and its linked articles.