Query against MySQL to tell where the files for the tables are.
I used to know a query in Oracle that did this, but I would like one in MySQL.
What I would like is this. I would like a query that told me the location and the names of the files where actual data in a mysql db stored on a linux server.
My plan is this. Find out where the data is stored, bring down the MySQLd and then back up the data files. In case of catastophic failure, I hope to be able to restore the data.