Importing new customers and orders since original database upgrade

**jwduke3d** · 20 Apr 2012, 06:20 PM

Since I originally installed v1.5, completed the database upgrade and installed the necessary mods for my new v1.5 cart I have had several orders and new customer registrations on my live 1.3.9 site.

If I run the DB upgrade again will this cause any issues with the mods that have been installed since I originally ran the upgrade?

Or should I somehow import only the customers and orders from my 1.3.9 DB to my 1.5 DB? (this post makes me think that's a very bad idea http://www.zen-cart.com/showthread.p...mport-Database)

Any help would be greatly appreciated, I have read the FAQs and searched this forum but I can't seem to find this specific question... Please point me in the right direction if I have missed something!

**schoolboy** · 20 Apr 2012, 07:09 PM

Fiddling with the database via phpMyAdmin is NOT recommended for the purpose you describe. There are just too many relationships between tables, ID's and fields, for your "fix" to work. It would be easier to:

1. Put your 1.3 AND your 1.5 stores into maintenance mode. (Stops any more writing to dbase while you fix things)
2. Link the OLD database with the new install. Put into maintenance mode too. Upgrade dbase. Reconfig any addons.
3. leave 1.3 store in maintenance mode.

**jwduke3d** · 20 Apr 2012, 07:33 PM

Originally Posted by schoolboy

Fiddling with the database via phpMyAdmin is NOT recommended for the purpose you describe. There are just too many relationships between tables, ID's and fields, for your "fix" to work. It would be easier to:

1. Put your 1.3 AND your 1.5 stores into maintenance mode. (Stops any more writing to dbase while you fix things)
2. Link the OLD database with the new install. Put into maintenance mode too. Upgrade dbase. Reconfig any addons.
3. leave 1.3 store in maintenance mode.

Thanks for the reply schoolboy!

I made this bed and it looks like I will have to lay in it!

Just so i'm clear as a very last step to my upgrade process (in an attempt to limit downtime) I should (while both carts are in Mx mode)...

1. link the old DB to the new v1.5 cart
2. run the upgrade
3. Run each of the SQL patches for the mods I have installed? and configure for use again.

Thanks again for the quick response!

**rstevenson** · 20 Apr 2012, 07:58 PM

Something I like to do in this circumstance... while in the 1.3.9h admin, print out the several key Configure screens -- such as Layout Settings, Index Listing, Product Info, as well as any from the Modules, Localization, and other menus -- so you can quickly reset everything once you've got your old database into your new 1.5.0 install. You don't need to waste a lot of paper doing this, just print to PDF, or even copy and paste to your text editor -- anything just so you have a convenient way to recover all those little settings you may need. Somebody (who knows what they're doing better than I) could perhaps make a mod for this. Easy for me to say.

Rob

**jwduke3d** · 20 Apr 2012, 08:11 PM

Thanks for the tip rob. I'm will certainly be doing something along those lines. I think the biggest issue im going to run into is the move from SSU to CEON. I had to manually input about 75 URIs into phpMyAdmin as to avoid tons of 301 redirects. I will attempt to save the CEON uri table before changing over databases. Hopefully it will import without problems.

**DrByte** · 21 Apr 2012, 02:34 AM

If it were me, I'd treat your 1.5.0 site that you've been staging as just that: a staging and testing area, which you throw away after you REDO your upgrade on your live site. The "redo" is way simpler because you've already done it and have detailed notes of all that you've done to prepare and test it.

Always safer to do it that way than to import data the opposite direction, especially since the structures are different etc.