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 |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: