Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Update database


ptityop

Recommended Posts

HI... I had a pb with my hosting company...they changed my server... while this change was happening some customers orders got registered on one database and the new one did not get the changes... so I now have the old database and a new one with differen info... Is there a way I can update the new database in order to get the info that did not get entered during the server change ....? many thanks

Link to comment
Share on other sites

If you just want to get the orders that were missed, back up the old db and edit the resulting file.

 

Delete everything except for the sections where the table name starts with orders.

 

Delete anything that relates to DROP tables.

 

Now delete off the lines that relate to the orders you have on the new db.

 

Save the file.

 

Hopefully there are just a few orders.

 

Now you can use this sql file and run it against your new db.

 

If there are new orders on your new db you will have to duplicated order numbers and will have to sort that out, and tell the customers concerned.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...