So here's the deal. I have 5 magento databases made a couple of months ago when I upgraded magento from 1.8.0 to

Now I need to archive these database (for backup purposes) according to their versions and last used since I made a couple of copies. I totally forgot to label any of these databases as to what their magento versions are or when I managed to download them.

I can tell that one has to be the version since it has no content yet but the other are 1.8 and I have no idea which was the original or which was the one I was going to upgrade to magento

What tables do I look at to check the last usage of the database?

1 Answer 1


Maybe try looking at the date/time orders were created? Assuming orders were coming in on the site when these different database copies were being used, that might give you some direction as to what database might've used when. You can start by looking in the catalog_product_entity table & there should be a field in there called created_at. I'm doing this off the top of my head, but hopefully that helps point you in the right direction.

  • that is actually a good suggestion. Will update you if your solution works. Time to dig into the database then.
    – fja3omega
    May 16, 2016 at 5:19
  • yup works for me. found the older database and made a backup of the new one. now off to testing extensions.
    – fja3omega
    May 16, 2016 at 7:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.