Jump to content

Compare Databases - Export missing orders

Recommended Posts



We are hosting a client's prestashop on a virtual machine, and last week it had a bad crash.

To avoid too much downtime, we quickly moved the site to a new machine and imported the latest

MySQL backups, from about 15 minutes before the crash. Worked fine since then, but now we'd

like to import the missing data from those lost 15 minutes between the backup and the crash,

I did repair the previous machines and have full access to the database.


I'm thinking I'd have to compare the two databases somehow to extract what's different,

since I'm guessing I'll have different orders with the same IDs. I'm no prestashop

expert though, what tables should I expect to have relevant data ?

Anyone having experiences doing this ? Any advices on tools to use ? I can probably even find

a windows computer to run the tool if needed, I guess.


There shouldn't have been any changes done by the administrators, and if there was it's probably

okay to just ignore them (they had all week end to re-do the changes), but we'd really need the orders.


Thanks !

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More