Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Restoring 2.2 database into 2.3.1


Ian Lawther

Recommended Posts

Due to a hack at the weekend I am having to rebuild my website and this has caused an unplanned move from 2.2 to 2.3.1. I saved a backup of my database to the computer before my host zapped my site and restarted everything. They assisted me in getting the dump back on to the website today before I loaded OsC again. Thinking I was linking to it I put the database name in during the installation and of course my old one got overwritten by the samples in the installation. ("Oh, bother" I said when I realized).

 

Since then I have read some posts that say that there were changes in the database set up between the two version which sound as if I cannot simply bring in the old database. Can anyone advise on the quickest and most efficient way of of getting information on around 1000 line items and almost as many customers into the new database.

 

Thanks,

Ian Lawther

PS Please speak slowly and clearly I'm not a techy.......

Link to comment
Share on other sites

Load up your old db. Load up a new DB.

 

Compare the two.

 

Remove anything from the old that is not in the new.

Add anything in the new to the old.

 

In other words, make the old have the same STRUCTURE as the new.

 

Done. Should not take you more than a morning.

Link to comment
Share on other sites

  • 1 month later...

Hi guys,

 

I have installed oscommerce 2.3.1 and would like to use my old database 2.2 ms2. I have configured includes/configure.php and admin/includes/configure.php to use the old database but Im not seeing the changes on my new installation. Please need assistant.

Link to comment
Share on other sites

John,

 

 

Your old MS2 database is NOT compatible with the new v2.3.1 database. You will have to manually insert the old data into the new database making changes to the tables and fields as required.

 

 

 

 

Chris

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...