在linux安装xampp,完毕后各中间件及数据库工作正常,但是数据库文件放在哪里呢?

其实一条命令即可解决此问题:

进入数据库后

MariaDB [(none)]> show variables like ‘%dir%’;
+—————————————–+——————————+
| Variable_name                           | Value                        |
+—————————————–+——————————+
| aria_sync_log_dir                       | NEWFILE                      |
| basedir                                       | /opt/lampp                   |
| binlog_direct_non_transactional_updates | OFF                          |
| character_sets_dir                      | /opt/lampp/share/charsets/   |
| datadir                                        | /opt/lampp/var/mysql/        |
| ignore_db_dirs                            |                              |
| innodb_data_home_dir               | /opt/lampp/var/mysql/        |
| innodb_log_arch_dir                     | /opt/lampp/var/mysql/        |
| innodb_log_group_home_dir               | /opt/lampp/var/mysql/        |
| innodb_max_dirty_pages_pct              | 75.000000                    |
| innodb_max_dirty_pages_pct_lwm          | 0.001000                     |
| innodb_tmpdir                           |                              |
| innodb_undo_directory                   | .                            |
| lc_messages_dir                         |                              |
| plugin_dir                                    | /opt/lampp/lib/mysql/plugin/ |
| slave_load_tmpdir                       | /tmp                         |
| tmpdir                                          | /tmp                         |
| wsrep_data_home_dir                 | /opt/lampp/var/mysql/        |
| wsrep_dirty_reads                        | OFF                          |
+—————————————–+——————————+
19 rows in set (0.00 sec)

 

清清楚楚的!

yantaisolo

作者 yantaisolo