查看MySQL数据库所在路径

zipalpha

配置文件中有一个datadir参数, 该参数制定了数据库所在的路径

1. mysql> show variables like 'datadir'\G
   
2. *************************** 1. row ***************************
   
3. Variable_name: datadir
   
4.         Value: /var/lib/mysql/
   
5. 1 row in set (0.00 sec)
   
6. 
   
7. mysql> system ls -lh /var/lib/mysql/data
   
8. ls: 无法访问 /var/lib/mysql/data: 权限不够
   
9. mysql>

查看配置文件:

1. [mysqld]
2. #
3. # * Basic Settings
4. #
5. 
   
6. #
7. # * IMPORTANT
8. # If you make changes to these settings and your system uses apparmor, you may
9. # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
10. #
11. 
    
12. user = mysql
13. socket = /var/run/mysqld/mysqld.sock
14. port = 3306
15. basedir = /usr
16. datadir = /var/lib/mysql
17. tmpdir = /tmp
18. skip-external-locking

1. keke@keke-VirtualBox ~ $ sudo ls -lh /var/lib/mysql/
2. 总计 21M
3. -rw-r--r-- 1 root root 0 2011-03-04 10:55 debian-5.1.flag
4. -rw-rw---- 1 mysql mysql 10M 2011-03-14 10:22 ibdata1
5. -rw-rw---- 1 mysql mysql 5.0M 2011-03-17 15:55 ib_logfile0
6. -rw-rw---- 1 mysql mysql 5.0M 2011-03-04 10:55 ib_logfile1
7. -rw-rw---- 1 mysql mysql 5 2011-03-17 15:55 keke-VirtualBox.pid
8. drwx------ 2 mysql root 4.0K 2011-03-04 10:55 mysql
9. -rw-rw---- 1 root root 6 2011-03-04 10:55 mysql_upgrade_info
10. drwx------ 2 mysql mysql 4.0K 2011-03-09 17:47 phpmyadmin
11. drwx------ 2 mysql mysql 4.0K 2011-03-04 11:20 test