Totally Zenned
- Join Date:
- Sep 2005
- Posts:
- 836
- Plugin Contributions:
- 0
Import Database
Can i install a fresh install of 1.50 and then import portions of my database including orders and customers from a 1.39 install?
Totally Zenned
Can i install a fresh install of 1.50 and then import portions of my database including orders and customers from a 1.39 install?
Totally Zenned
CnTGifts:
Can i install a fresh install of 1.50 and then import portions of my database including orders and customers from a 1.39 install?
Short answer, Yes you can. I did it that way for a client of mine that was running zen cart 1.3.8.
Is your site Upgraded to the current version 1.5.4 Yet?
zencart-upgrades-website-installation
Totally Zenned
whats the easiest way to go about it?
Totally Zenned
CnTGifts:
whats the easiest way to go about it?
You go to your v1.3.9 phpMyAdmin database, go to export and export the tables you want to import your zen cart v1.5.0 database. It's not a hard process unless you don't know anything about phpMyAdmin. If you don't know in that case you would hire someone to help you.
Is your site Upgraded to the current version 1.5.4 Yet?
zencart-upgrades-website-installation
Sensei
NO NO NO NO NO!!!!!!!!!!!!!!!!!!!!!
If you do that then you will have database tables that have different structures than what the PHP code expects, and will thus run into errors, and then you'll be back here asking for support on how to fix probably the hardest problem to ever sort out.
Do a COMPLETE backup, and import the COMPLETE database, and upgrade the COMPLETE database using zc_install. That's the smartest, safest, and official way to do an upgrade.
Clearly if you need to ask the questions you're asking then your knowledge isn't strong enough to handle all the zillion issues that will arise if you cheat in the process. Sorry if you find that statement offensive, but it's a fact, and if you bust everything by doing it the wrong way then it's going to cost you big bucks to get an expert to clean it all up for you.
There's NO NEED WHATSOEVER to take the shortcuts you're suggesting in your first post. Take the COMPLETE database forward to your new site.
If you don't understand why I'm saying that, then clearly you absolutely need to NOT take the shortcuts you're talking about.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
DrByte:
NO NO NO NO NO!!!!!!!!!!!!!!!!!!!!!
If you do that then you will have database tables that have different structures than what the PHP code expects, and will thus run into errors, and then you'll be back here asking for support on how to fix probably the hardest problem to ever sort out.
Do a COMPLETE backup, and import the COMPLETE database, and upgrade the COMPLETE database using zc_install. That's the smartest, safest, and official way to do an upgrade.
Clearly if you need to ask the questions you're asking then your knowledge isn't strong enough to handle all the zillion issues that will arise if you cheat in the process. Sorry if you find that statement offensive, but it's a fact, and if you bust everything by doing it the wrong way then it's going to cost you big bucks to get an expert to clean it all up for you.
There's NO NEED WHATSOEVER to take the shortcuts you're suggesting in your first post. Take the COMPLETE database forward to your new site.
If you don't understand why I'm saying that, then clearly you absolutely need to NOT take the shortcuts you're talking about.
DrByte I will agree with you that doing a complete backup of your old database is the best way to go about doing things and then using the zc_install, but in some cases that's not completely necessary. Smarter yes but not completely necessary on a fresh install of zen cart v1.5.0. And example would be when you start from scratch and wanting to import your orders and customers from your tables in your old database. That's my 2 cents worth.
Is your site Upgraded to the current version 1.5.4 Yet?
zencart-upgrades-website-installation
Sensei
I completely disagree if the database structures are not identical beforehand. And in this case the structures have SEVERAL HUNDRED DIFFERENCES. If you read the first post above, they're asking about doing an upgrade, which means their database structures are different.
And, since most people will make WAY TOO MANY incorrect assumptions about WHICH tables to copy, they have no business getting into that area whatsoever. Especially when they have no idea what they're doing and thus have no idea how to recover from it.
Are you volunteering to fix their problems for them, after they've follow your advice and they can't get their store working?
I know that I'm using strong language, and I mean no disrespect to anybody posting here or reading this. I have to keep in mind that this support site is for helping people USE their stores, not break them. To keep them running, not shut them down. They rely on correct answers, not answers that run them down the wrong path or into territories they've already indicated they don't belong in.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
countrycharm:
And example would be when you start from scratch and wanting to import your orders and customers from your tables in your old database. That's my 2 cents worth.and this can be accomplished by following a proper upgrade procedure. What's to be gained by bypassing the upgrade??
DrByte:
I completely disagree with your statement if the database structures are not identical beforehand. And in this case the structures have SEVERAL HUNDRED DIFFERENCES. If you read the first post above, they're asking about doing an upgrade, which means their database structures are different.
And, since most people will make WAY TOO MANY incorrect assumptions about WHICH tables to copy, they have no business getting into that area whatsoever. Especially when they have no idea what they're doing and thus have no idea how to recover from it.
Are you volunteering to fix their problems for them, after they've follow your advice and they can't get their store working?
I know that I'm using strong language, and I mean no disrespect to anybody posting here or reading this. I have to keep in mind that this support site is for helping people USE their stores, not break them. To keep them running, not shut them down. They rely on correct answers, not answers that run them down the wrong path or into territories they've already indicated they don't belong in.
Nods in agreement..:yes:
In my working experience, too often shortcuts lead to issues that take LONGER to fix than going the "long way" in the first place would have taken.. Folks need to just do it the right way and save yourself the headache.
I don't understand why people think they SHOULD/COULD shortcut the database migration.:no: What does this accomplish??? If you have data from old add-ons you want to get rid of (items in the configuration and configuration_group tables), RUN THE UNINSTALL SQL for that add-on before backing up and upgrading and the problem is solved..
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Totally Zenned
DivaVocals:
and this can be accomplished by following a proper upgrade procedure. What's to be gained by bypassing the upgrade??
Nods in agreement..:yes:
In my working experience, too often shortcuts lead to issues that take LONGER to fix than going the "long way" in the first place would have taken.. Folks need to just do it the right way and save yourself the headache.
I don't understand why people think they SHOULD/COULD shortcut the database migration.:no: What does this accomplish??? If you have data from old add-ons you want to get rid of (items in the configuration and configuration_group tables), RUN THE UNINSTALL SQL for that add-on before backing up and upgrading and the problem is solved..
DrByte:
I completely disagree if the database structures are not identical beforehand. And in this case the structures have SEVERAL HUNDRED DIFFERENCES. If you read the first post above, they're asking about doing an upgrade, which means their database structures are different.
And, since most people will make WAY TOO MANY incorrect assumptions about WHICH tables to copy, they have no business getting into that area whatsoever. Especially when they have no idea what they're doing and thus have no idea how to recover from it.
Are you volunteering to fix their problems for them, after they've follow your advice and they can't get their store working?
I know that I'm using strong language, and I mean no disrespect to anybody posting here or reading this. I have to keep in mind that this support site is for helping people USE their stores, not break them. To keep them running, not shut them down. They rely on correct answers, not answers that run them down the wrong path or into territories they've already indicated they don't belong in.
I didn't say this intentionally to start a conflict so I will bow out gracefully.
Is your site Upgraded to the current version 1.5.4 Yet?
zencart-upgrades-website-installation
Totally Zenned
countrycharm:
I didn't say this intentionally to start a conflict so I will bow out gracefully.
No conflict on my part. I simply wanted to point out that some of these upgrade shortcuts are not necessary and they don't "gain" anything. They can cause more issues than is necessary.
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Totally Zenned
Basically why i was asking is because i have addons on my current instal of 1.39 that some havent been upgraded yet.
So your saying i should overwrite all my files with the new 1.5 ones and then to the upgrade through zc_install?? And then just go on with installing the new add ons that are compatable?
Sensei
This is what you should do: https://www.zen-cart.com/upgrade
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
Also just from my own experience, I took the extra step of running the uninstall SQL for my add-ons before stepping through the upgrade process (the link DrByte posted). Since I was having to re-install all the add-ons from scratch anyway, I wanted to just bring forward a "cleaner" DB to upgrade. I found it made the add-on installs much cleaner later on..> CnTGifts:
Basically why i was asking is because i have addons on my current instal of 1.39 that some havent been upgraded yet.
So your saying i should overwrite all my files with the new 1.5 ones and then to the upgrade through zc_install?? And then just go on with installing the new add ons that are compatable?
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Tell staff why this post should be reviewed.