Does anyone know if it is possible to pull database names out of MySQL and display them in a table?
I've been asked to write a capacity report that displays databases currently hosted on a MySQL server. We have upto 50 databases located on a MySQL server. I've been told we also have another database that lists the databases so if I can run a statement to interrogate this database it should give me the info I want. If only we had a DBA here... If anyone has any ideas it would be much appreciated. Its a shame Appinsight doesn't work with MySQL...