树莓派重装系统 修复mariadb的datadir

系统损坏 重装系统后修复mariadb

安装数据库

 sudo apt install mariadb-server

测试启动正常

 sudo mysql -u root -p

停止mariadb服务

systemctl stop mariadb

创建新datadir

sudo mkdir /var/mdb

将数据文件复制过来

 sudo cp -p -r -f "/media/rootfs/var/lib/mysql" "/var/mdb"
 sudo chown -R mysql:mysql /var/mdb
sudo mkdir /var/mdb/lcdir
sudo cp -p -r -f "/media/rootfs/usr/share/mysql/" "/var/mdb/lcdir/"
 sudo chown -R mysql:mysql /var/mdb/lcdir

修改配置

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see

# this is read by