Debian系統升級MariaDB的流程如下:
mysqldump
工具備份所有數據庫,避免數據丟失。mysqldump -u root -p --all-databases > full_backup.sql
mysql
命令確認當前MariaDB版本。mysql -u root -p -e "SELECT VERSION();"
wget https://downloads.mariadb.org/MariaDB/mariadb_repo_setup
sudo dpkg -i mariadb_repo_setup.deb
sudo apt update
apt
命令升級軟件包。sudo apt upgrade mariadb-server
sudo systemctl restart mariadb
mysql -u root -p -e "SELECT VERSION();"
mysql -u root -p < full_backup.sql
注意事項:
參考來源: