This question is probably fairly stupid but I installed a couple instances of Magento (for various reasons) and I made the MySQL database names very similar. In fact they only vary by some arbitrary numbering system I made up (and have since forgotten). All the installations have very few accounts, items, etc that were setup.

I'm wanting to do some house cleaning and get rid of the databases associated with installations I no longer use. Is there an easy way to figure out which is which or should I just back them all up and play roulette with the delete button?


You will find the database name in the file app/etc/local.xml of each magento instance you have.
Figure out which instances you are not using and look in the file mentioned above at the tag <dbname>.

  • for magento2, it's in app/etc/env.php – kashish Jul 26 '17 at 7:17

Just for posterity, in newer versions of Magento this is kept in app/etc/env.php

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.