Server Administration & Management

MySQL database Directory

MySQL uses files to store data. By default, these data files are locate under the “/var/lib/mysql” directory, where databasename is the name of the database. Also we can store mysql database under desire location with the help of my.cnf, Basically my.cnf file is MySQL configuration file. MySQL Database are three file types:

.FRM –> file contain the table schema.
.ISD –> is the file that actually holds the data.
.ISM –> is the file that provides quick access between the two of them.

August 21, 2011 Posted by | MySQL | | Leave a comment