For New Users of MySQL

227

MySQL Server Configuration File

At startup time, the server uses its configuration file /etc/my.cnf as men 

tioned in this startup script. The default configuration file that came with my distribu 

tion of Linux 7.1 is shown below:

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

[mysql.server]

user=mysql

basedir=/var/lib

[safe_mysqld]

err log=/var/log/mysqld.log

pid file=/var/run/mysqld/mysqld.pid

Database Storage Files

Each database is stored in a directory under /var/lib/mysql top level direc 

tory (configurable through my.cnf file). For example, if you use  snort  as the data 

base name, all files in this database will be located in the directory /var/lib/

mysql/snort. You have used a script to create tables in this database in Chapter 5.

The typical contents of this directory after creating all tables is as follows:

[root@laptop]# ls  l /var/lib/mysql/snort

total 4080

 rw rw        1 mysql    mysql        8614 Apr 30 14:30 

data.frm

 rw rw        1 mysql    mysql           0 Apr 30 14:30 

data.MYD

 rw rw        1 mysql    mysql        1024 Apr 30 14:30 

data.MYI

 rw rw        1 mysql    mysql        8606 Apr 30 14:30 

detail.frm

 rw rw        1 mysql    mysql          40 Apr 30 14:30 

detail.MYD

 rw rw        1 mysql    mysql        2048 Apr 30 14:30 

detail.MYI

 rw rw        1 mysql    mysql        8614 Apr 30 14:30 

encoding.frm

 rw rw        1 mysql    mysql          60 Apr 30 14:30 

encoding.MYD

 rw rw        1 mysql    mysql        2048 Apr 30 14:30 

encoding.MYI