Upgrading MySQL Databases from MariaDB 5 to MariaDB 10?

by Jiondad posted Aug 21, 2023
?

단축키

Prev이전 문서

Next다음 문서

ESC닫기

크게 작게 위로 아래로 댓글로 가기 인쇄

 

Upgrading MySQL Databases from MariaDB 5 to MariaDB 10?

 

 

I just exported all of my MariaDB 5 databases and then imported them to MariaDB 10. I then turned off MariaDB 5. When I did so none of my WordPress websites would connect to the newly created MariaDB 10 databases. 

The ONLY way I was able to resolve this was to use Step 4 of this procedure: 

Steps:
1 backup MariaDB5 and MariaDB10 (option in Hyperbackup)
2 export all databases from MariaDB5 to a sql dump (option in PhPmyadmin)
3 import sqldump in MariaDB10 (option in PhPMyadmin)
4 edit wordpress wp-config.php: search for "define('DB_HOST', 'localhost');" and change in define('DB_HOST', 'localhost:/run/mysqld/mysqld10.sock');

Why is this necessary?

If MariaDB 5 is deactivated, shouldn't the Synology NAS automatically default to MariaDB 10?