Altered Database tables in 1.5.x?

Hi all.

What tables are changed between 1.3.9h and the latest version of 1.5.x?

I ask because I want to build a fresh install of my site from scratch and when ready to go live I want to import products categories, orders etc

Can anyone advise?

Thanks

Phil

WE NEVER RECOMMEND COPYING JUST A FEW SELECTIVE TABLES BETWEEN DATABASES!!!!!!

That said, if you think you've got the expertise needed to do that safely, then you should simply run the zc_install "Database Upgrade" step on the old database before copying any data from it into the new site's database. That way the schema changes will be handled properly ... which appears to be the root question from your post.

Well I guess what I'm asking is if none of the product/customer/order tables have changed then once I have a fresh install ill just drop the relevant table and I seer the old ones.

But I'd need to know if this would work, I.e have this tables been changed in any way?

philip937:

Well I guess what I'm asking is if none of the product/customer/order tables have changed then once I have a fresh install ill just drop the relevant table and I seer the old ones.

But I'd need to know if this would work, I.e have this tables been changed in any way?
No this won't work or it would be included in the upgrade instructions .. (see Dr Bytes post) Suggest following recommendations, do the upgrade and don't look for a shortcut.. There's no gain/upside to the path you are wanting to take.

DivaVocals:

No.. (see Dr Bytes post) Suggest following recommendations, do the upgrade and not looking for a shortcut..

Well what I'm suggesting is far from a shortcut! The shortcut is upgrading an old database, I am suggesting using a new database and importing certain data!

philip937:

Well what I'm suggesting is far from a shortcut! The shortcut is upgrading an old database, I am suggesting using a new database and importing certain data!
Then you have your answer.. What you are suggesting is not recommended. The best way to update the database is by following the recommended upgrade path as per Dr Bytes post.

What about old configuration entries for mods that are not compatible with 1.5.x that weren't supplied with uninstall SQL? Which by the way I think should be mandatory to provide for any mods in the download section.

Fair enough ill give it a go with the old db and try and clean it up somewhat.

philip937:

What about old configuration entries for mods that are not compatible with 1.5.x that weren't supplied with uninstall SQL? Which by the way I think should be mandatory to provide for any mods in the download section.

Fair enough ill give it a go with the old db and try and clean it up somewhat.if you think you know enough to selectively upgrade your DB then you should be able to put together an uninstall script.. not sure which add-ons you're using but unless it's old, I don't know very many without an uninstall script.

I said I could drop and insert tables on the proviso they are not altered in the new version. And I am capable of removing entries and creating a script I was merely suggesting we shouldn't have to and they should be included in the download.. Chill

philip937:

I said I could drop and insert tables on the proviso they are not altered in the new version. And I am capable of removing entries and creating a script I was merely suggesting we shouldn't have to and they should be included in the download.. Chill
Well we can go back and forth about all the things you should and shouldn't have to do.. That won't solve your problem.. Based on your post, you have an add-on that has no uninstall script.. So apparently you do have to do some work to remove the DB entries for these add-ons.. Here's what I suggest..

1. Follow the upgrade instructions as Dr Byte advises.. (he is after all the BEST source of the correct method to do this)
2. If your mods really do not have any kind of uninstall script, and you do not know how to back out the DB entries created by them, then you can check the support thread for your add-ons for options to remove the DB entries created by your add-ons..

Good luck..

Thanks for your input guys

delete duplicated post grrrrr

Actually just had a thought, main reason for my thinking is that I'm obviously not going to perform the upgrade on my live site. Therefore whilst I'm upgrading and developing/testing I will still be getting customers & orders on original database.
How would you suggest I deal with that?

philip937:

Actually just had a thought, main reason for my thinking is that I'm obviously not going to perform the upgrade on my live site. Therefore whilst I'm upgrading and developing/testing I will still be getting customers & orders on original database.
How would you suggest I deal with that?

If you are following the upgrade instructions in the FAQ, this is covered in the upgrade instructions..

philip937:

Actually just had a thought, main reason for my thinking is that I'm obviously not going to perform the upgrade on my live site. Therefore whilst I'm upgrading and developing/testing I will still be getting customers & orders on original database.
How would you suggest I deal with that?
I wrote a blog post on that very topic:
http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading
I believe there's a link to that blog post in the FAQs on upgrading at https://www.zen-cart.com/upgrade

As a follow up to this......

Upgrade Path for me is a bit different and I want to understand it before go time.

I have created a localhost version with a new database. I imported my old data into it so that I could have something to work with. While I do this, my old version is cranking away getting new sales. So.....

1. Finish 1.5.1 "tweaking" and Module additions for localhost (Current Database has the EXACT same name as my server)
2. Backup my old database.
3. Upload the entire "tweaked" 1.5.1 directory to my server.
4. Run zc_install and choose "Database Upgrade"
5. Test site further to ensure everything works......

Does this sound right? I only ask is that I have no seen an upgrade path for a localhost type testing. Am I missing anything?

Thanks
Chris

As I said in my last post, I address that issue here: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading