The live database should continue to operate and process orders until the new store is being put into place and operational.... What that means is while you are testing your rebuild/upgrade the database that you are accessing should be independent of your live site and *WILL* become out-of-date... Once the upgrade looks like it is good *AND* you have tested doing the upgrade of the database (import of copy of live store to this rebuild area and database upgrade), *THEN* it is time to temporarily place the live site in maintenance mode, either move the files or redirect visitors to your new location so that access to your normal site location is to the new fileset. Before again taking the site out of maintenance mode, update the database, verify that store is operational and then take it out of maintenance mode.
The time during which the site is in maintenance mode based on the above could be as short as a few minutes but plan for about an hour just to be sure that all is working as it should...
As far as the issue about doing this potentially dangerous database data move, which even now your new site is going to have out-of-date information, the table should only be created if it is missing or doesn't exist:
Code:
CREATE TABLE IF NOT EXISTS `orders`(
This should be a selection option when exporting the existing table from phpMyAdmin, though there still is the concern about other records that *should* be moved, but have not been selected.
Please re-review the guidance on updating: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://docs.zen-cart.com/user/upgrading/detailed_upgrading/[/FONT]
Bookmarks