Logical1 Posted March 10, 2009 Share Posted March 10, 2009 Computer on the web server crashed and we are checking the hard drive to see if we can recover he MyQL tables. We used PhpMyAdmin to work with them and in reality do not know the location of the tables. How can we find them? The hard drive is OK but the guy trying to find the tables can not locate them altough we have upplied him with the table names. Any ideas? Thank in advance. Quote Link to comment https://forums.phpfreaks.com/topic/148708-how-to-locate-mysql-tables/ Share on other sites More sharing options...
aschk Posted March 10, 2009 Share Posted March 10, 2009 Assuming a linux server, and also assuming default directories, they should be located inside /var/lib/mysql , however some people choose to install in /usr/local/mysql-x.x.x (where x represents version part) Quote Link to comment https://forums.phpfreaks.com/topic/148708-how-to-locate-mysql-tables/#findComment-780997 Share on other sites More sharing options...
Mchl Posted March 10, 2009 Share Posted March 10, 2009 Fin the configuration file for mysql (it should be in mysql directory, usually called my.ini) There you should have entry named datadir= It should contain the path to data directory. Backup both my.ini and WHOLE data directory Also try to find out which MySQL version you were using. Quote Link to comment https://forums.phpfreaks.com/topic/148708-how-to-locate-mysql-tables/#findComment-781012 Share on other sites More sharing options...
Logical1 Posted March 10, 2009 Author Share Posted March 10, 2009 Thank you guys for your helpful and precise answers. Quote Link to comment https://forums.phpfreaks.com/topic/148708-how-to-locate-mysql-tables/#findComment-781422 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.