MySQL 查看数据库文件所在

最新推荐文章于 2023-05-08 13:53:38 发布

crazy-tiger

最新推荐文章于 2023-05-08 13:53:38 发布

阅读量771

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/u013490280/article/details/109978616

版权

MySQL 专栏收录该内容

14 篇文章 2 订阅

订阅专栏

老是忘记记一下。

mysql> show variables like '%dir%';
+-----------------------------------------+---------------------------------------------------------+
| Variable_name                           | Value                                                   |
+-----------------------------------------+---------------------------------------------------------+
| basedir                                 | C:\Program Files\MySQL\MySQL Server 5.7\                |
| binlog_direct_non_transactional_updates | OFF                                                     |
| character_sets_dir                      | C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\ |
| datadir                                 | C:\ProgramData\MySQL\MySQL Server 5.7\Data\             |
| ignore_db_dirs                          |                                                         |
| innodb_data_home_dir                    |                                                         |
| innodb_log_group_home_dir               | .\                                                      |
| innodb_max_dirty_pages_pct              | 75.000000                                               |
| innodb_max_dirty_pages_pct_lwm          | 0.000000                                                |
| innodb_tmpdir                           |                                                         |
| innodb_undo_directory                   | .\                                                      |
| lc_messages_dir                         | C:\Program Files\MySQL\MySQL Server 5.7\share\          |
| plugin_dir                              | C:\Program Files\MySQL\MySQL Server 5.7\lib\plugin\     |
| slave_load_tmpdir                       | C:\WINDOWS\SERVIC~1\NETWOR~1\AppData\Local\Temp         |
| tmpdir                                  | C:\WINDOWS\SERVIC~1\NETWOR~1\AppData\Local\Temp         |
+-----------------------------------------+---------------------------------------------------------+
15 rows in set, 1 warning (0.00 sec)