Update database

[ptityop]

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

[♥geoffreywalton]

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.