在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)
清清楚楚的!