Database

[zapme1]

Hi All....

I've been running ZC v1.3.9h (forever) with MANY Modifications! Finally doing the upgrade......
I created a new store with v1.5.7c, loaded my template and successfully migrated my Original Database using zc_install.....

Things are going pretty good with a few bugs to workout!
I have more customizations to make on the new v1.57c site, and a couple of new plugins that I want to install and test all before going live!

My original store running v1.3.9h is still live & taking new customers and orders.....


Here is my question.....

When I'm ready to go live with my New v1.5.7c store, is there ANY easy way to transfer the New Customers & New Purchases (since the original migration) from the old store to the new?

Thanks!

* UPDATE *

My upgraded site is near ready!
I just need to "upgrade my database" using ZC_INSTALL to the most current from my old site to the new.....

BUT.... I have an issue!
I do not have the "Upgrade" Button...!

How can I upgrade my database???

[zapme1]

The inspection suggests that my database on my New site is "current", but there are several updates in the latest SQL from the old site!

[swguy]

https://docs.zen-cart.com/user/upgra...er_no_upgrade/

[zapme1]

https://docs.zen-cart.com/user/upgra...er_no_upgrade/

LOL... Thanks swguy! I had a feeling that this was the answer that I'd get.
I've read those docs at least 3-4 times already....

My New/Test site has been up and running for a few weeks now "after" I upgraded the new site DB with the old site DB using zc_install!
All has been working very well through all of my tests!
So I'm very sure that my configure.php is correct!!

The ONLY difference between the OLD-site-DB (which I need to import) and the NEW-site-DB, is a number of new customers & orders over the past few weeks.....

The installer tells me that my DB (new site) is "current", and from what I've read, this eliminates the upgrade button!?!
But it's NOT Current!!!

[mc12345678]

There's some additional information that could be given to help "correct" the issue.

It sounds like the current situation is this: a development store was created that had its own database location. The store was developed/upgraded to look and operate as desired. At some point a copy of the live store's database was copied into this development store, but now it is out-of-date.

Now the question here is what has happened next? Which files were copied to where, what database settings (references) were changed, etc...

Often, when the install only button is presented, it is because of a few things: first, the DB_PREFIX of the "new" includes/configure.php doesn't match the "old". Another is that the includes/configure.php file points to the development location that still has an updated database instead of a copy of the live database that needs updating.

This is where it is important to understand the condition of the store and which database contains what information and what needs to be done.

[mc12345678]

LOL... Thanks swguy! I had a feeling that this was the answer that I'd get.
I've read those docs at least 3-4 times already....

My New/Test site has been up and running for a few weeks now "after" I upgraded the new site DB with the old site DB using zc_install!
All has been working very well through all of my tests!
So I'm very sure that my configure.php is correct!!

The ONLY difference between the OLD-site-DB (which I need to import) and the NEW-site-DB, is a number of new customers & orders over the past few weeks.....

The installer tells me that my DB (new site) is "current", and from what I've read, this eliminates the upgrade button!?!
But it's NOT Current!!!

Sounds like you "need" to import your live site database now into your development site.

The question here though is, what is the intended result? If it gets updated in your development site, what is to be done next to apply all this work to the live site?

Are you simply trying to practice the upgrade portion of the process? E.g when you copy the live site to your development site, any changes that have been made to the database in the development site, basically will be removed and need to be redone. Did you prepare for that? Are you practicing going through that motion to minimize your down for maintenance time period?

It is *not* suggested to have your customers change how/where they go to access your store content. E.g. It is not suggested that instead of a domain name that they now have to access a domain name and a new or different sub-folder. It's not the worst thing that can be done, but not suggested if you can avoid it.

[swguy]

You need to re-do the zc_install:

- pull in OLD-db
- run zc_install (you *will* get the Upgrade button now)
- apply whatever db changes you did while testing your upgrade (switching templates, installing new plugins, etc.)

[swguy]

This might help clarify:

https://docs.zen-cart.com/user/upgra...ading/#go-live

[zapme1]

Okay, let me see if I can put all of this together.....

Original plan:
Create an brand new Zen Cart in a separate folder with the latest version...... DONE
"Upgrade" the New Zen Cart DB with the LIVE-Site DB..... DONE
Make Cosmetic changes (little to no DB changes) and TEST all Functions.... DONE

This is where I'm at now!

I believe that I'm ready to go LIVE....

My thoughts were to "update" the NEW site with the LIVE Site-DB once again to make it most current!
(This is where I'm stuck right now without the "upgrade" button)
Then a few more tests to be sure all is working.
Finally, I had planned to point my Domain to the NEW Site Folder to go LIVE.....

----------------------------

So, with all of that said, maybe the easiest completion is to rename the New Site Folder to the Same as the Old, and point the "configs" to the Old/Live DB as well.....!!

Does this make sense, and is "renaming" the easiest way to finish this?

Thanks for all of the help & patience!!

[swguy]

> My thoughts were to "update" the NEW site with the LIVE Site-DB once again to make it most current!

Correct. You need to run zc_install with your live database as part of your golive procedure.

> So, with all of that said, maybe the easiest completion is to rename the New Site Folder to the Same as the Old, and point the "configs" to the Old/Live DB as well.....!!

You can do this - you'll have to put zc_install back in the new site folder and re-run zc_install of course.