Linux CentOS 下面查看mysql数据库表存放的物理位置方法如下:[root@ip~]#mysql -uroot
mysql> show global variables like "%datadir%";
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)
另一个方法如下: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/ |
| innodb_data_home_dir | |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| plugin_dir | /usr/lib64/mysql/plugin |
| slave_load_tmpdir | /tmp |
| tmpdir | /tmp |
+-----------------------------------------+----------------------------+
10 rows in set (0.00 sec)
在mysql控制台输入以上命令,即可了解在Linux CentOS 下面mysql数据库物理存放目录路径信息。
注意:以上方法仅供参考。
【打印本页】
【关闭窗口】