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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

toronto web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved