brianlange Posted July 27, 2010 Share Posted July 27, 2010 I am migrating servers and trying to determine how large the data files for my mysql database are. Where are these files stored? Is there a mysql command that will show the location? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/209030-how-to-locate-data-files/ Share on other sites More sharing options...
systemick Posted July 27, 2010 Share Posted July 27, 2010 I use Fedora 12 and on my machine they are located in /var/lib/mysql but on a different OS they will be in a different place. my.cnf is the main mysql config file and the location should be listed in there. On Linux it is usually located in the /etc directory. If all else fails try searching your machine for a file or directory that is the same as the name of one of your databases. Quote Link to comment https://forums.phpfreaks.com/topic/209030-how-to-locate-data-files/#findComment-1091822 Share on other sites More sharing options...
brianlange Posted July 27, 2010 Author Share Posted July 27, 2010 Thanks for the response. I went to "Variables" in phpMyadmin and there was one for datadir. Quote Link to comment https://forums.phpfreaks.com/topic/209030-how-to-locate-data-files/#findComment-1091872 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.