Fresh install on new server, but want to migrate customers and products

[scrap]

Hi
I just bought myself a new, faster and better, server onto which I plan to migrate my Zen Cart store. I'm currently running 1.3.8a and of course, I want to upgrade to 1.3.9g.

My initial plan was to migrate my store to the new server (https://www.zen-cart.com/tutorials/i...hp?article=100), fiddle with the upgrade to 1.3.9g on the new server, and point my domain to the new server when everything was set.
However, now when I think of it, I'm not sure how to keep my new store in sync with my old, i.e. how to avoid the loss of newly signed up customers and newly added products while I work on the new store. After all, my time frame is like one month...

Knowing that I have two servers (plus an additional locally), what would be the easiest way to do the upgrade? I don't mind rebuilding some parts of the site. In fact, I wouldn't mind rebuilding the whole store as long as my customers and products were transfered.

[Out2lunch]

Grab the Backup Database addon, then move a copy of the db accross to the new site and load it in useing the same addon.

The your new site will have all of the dataup till the db port. Then when your ready do it again, just before you change the domain forward, put the car into Maintenance mode, then forward the domains. that way you shouldnt loose the any moer clients etc.

Then once the new site has the latest ver of db, and the domain forwarding has completed it will look like you have taken the site of maintenance then its up and running, and nothing will be lost.

[scrap]

Grab the Backup Database addon, then move a copy of the db accross to the new site and load it in useing the same addon.

The your new site will have all of the dataup till the db port. Then when your ready do it again, just before you change the domain forward, put the car into Maintenance mode, then forward the domains. that way you shouldnt loose the any moer clients etc.

Then once the new site has the latest ver of db, and the domain forwarding has completed it will look like you have taken the site of maintenance then its up and running, and nothing will be lost.

Ok, but what about product images? Is that a matter of simply copy them over as well?

I have to look into that database addon... as of now I'm using phpmyadmin. Perhaps the db addon is simpler.

[DrByte]

Ok, but what about product images? Is that a matter of simply copy them over as well?

Yes. FTP is your friend there.

[scrap]

Yes. FTP is your friend there.

Ok, so all I have to do is to put the live site in maintenance, migrate the DB to the new server, copy all images, point the domain to the new server and wait for the DNS to propagate(?) Sweet :)

*** for search engines *** :)

I was fiddeling with my large database as well. However, I solved it using Bigdump ( ozerov.de/bigdump.php ) and unticking "Extended inserts" when exporting the DB using phpmyadmin.

But, for everyone else having issues with a large database, check your zen_email_archive table. As it turned out, a huge portion of my total database size could be explained by zen_email_archive.
Consider exporting the full database as backup, empty the zen_email_archive table and exporting the database again to use in your new store/server.

[DrByte]

Ok, so all I have to do is to put the live site in maintenance, migrate the DB to the new server, copy all images, point the domain to the new server and wait for the DNS to propagate(?) Sweet :)

Well ... it's not exactly that simple. You've gotta do your upgrade first.

[scrap]

Well ... it's not exactly that simple. You've gotta do your upgrade first.

Thank you

I've migrated the shop to another server and done the upgrade to 1.3.9h, everything went just fine. Just after the migration I downloaded the live (1.3.8a) DB again, copied the images to the new server, dropped all the tables, imported the 1.3.8a DB, copied the zc_install to the new server an ran a db upgrade again, just to try it out. I suppose this is the way to do it?

However, the past month now I've done quite a lot of admin changes on the new server version (VAT, shipping, zones) and also (re)installed some addons that also configures the DB (Image Handler 2 rev8c, Google Analytics, EasyPopulate). When I move my live site again, can I select-->export-->import-->upgrade only specific tables, or should I just DL the new server version reconfigure all settings again just to be "safe"?

[kobra]

Just after the migration I downloaded the live (1.3.8a) DB again, copied the images to the new server, dropped all the tables,

However, the past month now I've done quite a lot of admin changes on the new server version (VAT, shipping, zones) and also (re)installed some addons that also configures the DB (Image Handler 2 rev8c, Google Analytics, EasyPopulate). When I move my live site again, can I select-->export-->import-->upgrade only specific tables, or should I just DL the new server version reconfigure all settings again just to be "safe"?

While I may get chided by others...

If you do a proper DB backup through phpmyadmin, you do not need to drop tables first as it does this

https://www.zen-cart.com/tutorials/i...hp?article=103

If you added modules that add tables to the DB that were not in used in your old shop, these will not be dropped/affected in the import to the new DB

I have had good success at doing what you are attempting in general by creating the backup of the old DB BUT not including the configuration table. This leaves that table intact on the new DB and is where most all added module specifics are contained...

You can try this method but as always, backup first in the event there is a issue

[DrByte]

I've migrated the shop to another server and done the upgrade to 1.3.9h, everything went just fine. Just after the migration I downloaded the live (1.3.8a) DB again, copied the images to the new server, dropped all the tables, imported the 1.3.8a DB, copied the zc_install to the new server an ran a db upgrade again, just to try it out. I suppose this is the way to do it?

Yes, that is the recommended way.

However, the past month now I've done quite a lot of admin changes on the new server version (VAT, shipping, zones) and also (re)installed some addons that also configures the DB (Image Handler 2 rev8c, Google Analytics, EasyPopulate). When I move my live site again, can I select-->export-->import-->upgrade only specific tables, or should I just DL the new server version reconfigure all settings again just to be "safe"?

It is safest to redo the conversion using your live database, and then reconfigure all the settings afterward.

If you wish to pick-and-choose what you convert, you just leave yourself open to errors, missing settings, damaged data, and more headaches and having to come back here asking for help to fix whatever you broke.
Maybe kobra will volunteer to fix your mistakes for you for free if you follow his advice.

[scrap]

Thanks guys! I just tried the Kobra version out. Please let me know if I'm way over my head here

I installed a local copy of the 1.3.9h site, downloaded the 1.3.8a database with some exceptions (ignoring ezpages, google_analytics, configuration, countries, geo_zones, currencies, tax_class, tax_rates, zones and zones_to_geozones) with DROP checked, and then imported the DB into the 1.3.9h version and ran the zc_install DB upgrade. I got one error message "Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists", but it all seems to be working just fine. Of course, I've checked the Admin-->Config-->My store-->Split tax option.