http://bbs.csdn.net/topics/390620630
Mysql> Show variables like '%dir% ';
+-----------------------------------------+----------------------------+
| variable_name | Value |
+-----------------------------------------+----------------------------+
| Basedir | /usr |
| Binlog_direct_non_transactional_updates | OFF |
| Character_sets_dir | /usr/share/mysql/charsets/|
| DataDir | /var/lib/mysql/|
| Ignore_db_dirs | |
| Innodb_data_home_dir | |
| Innodb_log_group_home_dir |./|
| innodb_max_dirty_pages_pct | 75 |
| INNODB_MAX_DIRTY_PAGES_PCT_LWM | 0 |
| Innodb_undo_directory |. |
| Lc_messages_dir | /usr/share/mysql/|
| Plugin_dir | /usr/lib/mysql/plugin/|
| Slave_load_tmpdir | /tmp |
| Tmpdir | /tmp |
+-----------------------------------------+----------------------------+
The database file defaults to: Cd/usr/share/mysql
Configuration file by default in:/ETC/MY.CNF
———————————–
Database directory:/var/lib/mysql/
Configuration file:/usr/share/mysql (mysql.server command and configuration file)
Related commands:/usr/bin (mysqladmin, mysqldump, etc.) (*mysql a Safe Boot method:/usr/bin/mysqld_safe–user=root &)
Startup script:/etc/rc.d/init.d/
First you can use the following command to find MySQL
[[email protected]/]# Find/-name "MySQL"-print
In general, MySQL is placed under the/usr/local/mysql/.
Then in its bin directory there is a mysql_config file, vi, you will see such a sentence:
Ldata= '/usr/local/mysql/var '
RPM Installation Default directory:
Data file:/var/lib/mysql/
Profile Template:/usr/share/mysql
MySQL Client Tools catalog:/usr/bin
Log directory:/var/log/
Pid,sock file directory:/tmp/
MySQL data file storage location under Linux