How to know magento 1.9 version Using MySql?

Question

I am having Magento1 Database details. Using that can we get the version of Magento?

I found it can get with files or with some custom code. I am looking to get from the Database. In which table does it store the version?

Please, anyone, suggest the answer.

Please open this link here you get your solution magestore.com/magento-2-tutorial/magento-version — Rv Singh, Commented Jul 24, 2018 at 5:52
Please read the question properly. I am trying to get it from mysql query. Is that possible? — Jafar Pinjar, Commented Jul 24, 2018 at 6:09

Mohit Kumar Arora · Accepted Answer · 2018-07-24 06:38:20Z

3

Magento 1.x does not save its version information in the database tables. Instead, its version is set in the app/Mage.php file.

Wherever it needs to show the Magento version, it calls Mage::getVersion() function, which is hardcoded in the app/Mage.php file.

Therefore, you will need to follow the same process.

Please let me know if anything is unclear in my answer.

answered Jul 24, 2018 at 6:38

Mohit Kumar Arora

10.2k7 gold badges28 silver badges56 bronze badges

I am clear about this. So we can't get the version of magento using DB connection string is it?
– Jafar Pinjar
Commented Jul 24, 2018 at 6:50
Yes, you are right.
– Mohit Kumar Arora
Commented Jul 24, 2018 at 6:54

Add a comment |

Murtuza Zabuawala · Accepted Answer · 2019-04-04 11:05:03Z

2

Directly from database its difficult but you can do with this trick

In magento database you will get core_config_data table

in that table you will get base_url

then hit that baseUrl/downloader in your browser.

if downloader is not secure in that site you will see login page and in that page you can see magento version

answered Jul 24, 2018 at 6:56

Murtuza Zabuawala♦

14.8k10 gold badges45 silver badges75 bronze badges

Add a comment |

Rohan Hapani · Accepted Answer · 2018-07-21 14:11:46Z

0

There are so many ways into this below link to check magento version. You can check using that :

answered Jul 21, 2018 at 14:11

Rohan Hapani

17.5k9 gold badges55 silver badges96 bronze badges

Can you please read my question ? Can we get using mysql connection string?
– Jafar Pinjar
Commented Jul 23, 2018 at 9:30

Add a comment |

3 Answers 3