My problem is to find out the exact version of Magento (should be one of CE) having only a database dump and no filesystem. So the method with the backend / Mage.php is not an option.

1 Answer 1


You can get that analyzing 'core_resource' table.

If you will know which sql updates were executed in which version of magento.

  • Yes, I've already tried to determine the version by checking the versions in core_resource. Unfortunately there are only versions of different modules and nothing indicating the Magento version directly. My first idea was to search for a list of core_resource's versions which will indicate to the Magento version, but I haven't found anything.
    – mryvlin
    Jan 27, 2014 at 14:03
  • Pretty much the way it is. There isn't any strict module versioning that you could go off of to determine the Magento Install version. I find it kind of annoying. Jan 27, 2014 at 23:47
  • its the perfect solution, as every magento version has specific module versions, which are represented in core_resource table.
    – Flyingmana
    Jan 28, 2014 at 1:58
  • @Flyingmana I don't see the modules represented in core_resouce. And I think it makes no sense as some modules do not require any database data. (e.g. Lib_Js_Mage)
    – jonazu
    Dec 15, 2014 at 13:07
  • I just did an update from CE 1.7 to CE 1.9.1 and it's just not possible to do any conclusions for the actual Magento version from the core_resource table. For example: catalogsearch_setup before update:, after update: And that's the highest version number from any of the magento core resources. (there are other version entries from extensions with higher numbers.)
    – jonazu
    Dec 15, 2014 at 13:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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