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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.