原来的系统重新安装系统盘后,再安装MariaDB ,如果还要使用原来的数据库:
#--------------------------add by root-----------------------------
# add for moving data to /data/mysql_data
# vim /etc/my.cnf.d/server.cnf 在[mysqld]标签下添加如下内容
# https://www.cnblogs.com/ld1977/p/7264485.html
#原目录
datadir=/opt/mysql
socket=/var/lib/mysql/mysql.sock
character_set_server=utf8
slow_query_log=on
slow_query_log_file=/opt/mysql/slow_query_log.log
long_query_time=2
#--------------------------add by pxzhao-------------------------
innodb_buffer_pool_size=64M
datadir=/opt/lib/mysql
socket=/var/lib/mysql/mysql.sock
character_set_server=utf8
slow_query_log=on
slow_query_log_file=/opt/lib/mysql/slow_query_log.log
long_query_time=2
#--------------------------add by pxzhao-------end------------------