Question: Where does MySQL store its database? In any operating system, but especially Linux, where does MySQL store all the databases? If in Linux, which directory is the data stored in? I want to create a database server but want to make sure that I get a separate hard drive for all the MySQL data. Therefore, if I know exactly where the data is stored, I can store that directory on a separate (bigger) hard drive.

Answer: Mysql keep its data in /var/lib/mysql folder incase you feel to reinstall the mysql you can allways copy this files using cp -rvp * to some folder keeping its permissions same and then you can reinstall mysql and move these files to  /var/lib/mysql folder.\n\nany more help buzz me at kshounish@yahoo.com\n\nkshounish
This question from the Yahoo Q&A forum is categorized in the topic: Education & Reference