ServerWeb service

Ubuntu 18.04 MariaDB10.4 Upgrade

MariaDB 10.3 > MariaDB10.4 업그레이드

  1. Check the MariaDB version currently installed on the server
# mysqladmin -p version

2. MariaDB root access

# sudo mysql -u root -p

3. SET GLOBAL innodb_fast_shutdown = 0; input

# SET GLOBAL innodb_fast_shutdown = 0;

After entering, type ctrl+c and exit

4. MariaDB full backup

# mysqldump -u root -p -A > /DBbackup.sql

reference : MariaDB Backup Recovery

# mysql -u root -p < DBbackup.sql

5. Enter in the order below

설치버전 다운로드 경로 확인

# sudo apt-get install software-properties-common
# sudo apt-key adv –fetch-keys ‘https://mariadb.org/mariadb_release_signing_key.asc’
# sudo add-apt-repository ‘deb [arch=amd64,arm64,ppc64el] http://mirror.mva-n.net/mariadb/repo/10.4/ubuntu bionic main’
  • Check installed version (Existing installed version and installable version are indicated)
# sudo apt-cache policy mariadb-server

6. Install MariaDB

# sudo apt update
# sudo apt install mariadb-server

installation in progress (Y / n) Enter Y in

Then enter the root password

7. Check installation status

# sudo service mysql status
  • Check php integration module
# sudo apt-cache policy php7.3-mysql
  • Install if not installed
# sudo apt-get install php7.3-mysql

Show More
vera soap
vera soap

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button