CODEWITHSUNDEEP
databasemagento
Kichu
Kichu

Reputation: 3267

How to maintain magento 1.4.1.1 database to magento 1.7.0.2

I have two domains:

1.main domain  : which have magento 1.4.1.1 site
2.sub domain   : which have magento 1.7.0.2 site(this site is upgraded from magento 1.4.1.1)

That means in my sub domain it had magento1.4.1.1 magento as in the main domain in past.

Then i uprgaded the magento site to 1.7.0.2 in sub domain.

The client now using the main domain and they use the old databse.

In my sub domain i have new database and i imported the db backup . But this backup was taken from before two months. That means the db backup is two months old. So in main domain ,the client enter new datas into the old database. After importing databse in subdomain i upgraded the site to 1.7.0.2

So i want to put all changes in the old database to new databse.

The old database have 329 tables and new database have 367 tables

How can i do this?

Upvotes: 0

Views: 966

Answers (1)

Ivan Chepurnyi
Ivan Chepurnyi

Reputation: 9233

The best option in your case:

  1. Get dump of old database.
  2. Setup the copy of the new codebase on another subdomain.
  3. Load dump into new database and point newly created subdomain codebase to it.
  4. Magento will automatically update the structure of the database.
  5. If any error appear during upgrading of old database to new one, you can fix it without letting old website down (separate db, separate instance). If no errors were found, you can turn off old website, upgrade db, and upload new code base.

Upvotes: 3

Related Questions