#Update mysql in centos install#
Yum install perl-DBD-MySQL php-mysqlnd postfix postgrey rebuild the databases Systemctl start mariadb reinstall packages removed with mariadb !!!NOTE – must be mysqlnd or will have library conflicts Yum -y install MariaDB-server MariaDB-client ensure the mariandb service is started Yum clean all re-install mariadb against the current config Yum remove mariadb-server mariadb mariadb-libs Mysqldump -u root -p -all-databases > all-databases.sql create a mariadb yum repo configĬat > /etc//MariaDB10.repo << EOF MariaDB 10.3 CentOS repository list.
#Update mysql in centos update#
Yum update create a backup of the current databases Need to backup DBs and will have a little bit of downtime (15 mins tops) ensure the system is up to date Update required to get MariaDB 10.3 instead of MariaDB 5.5. So just apply the same thing there (i assume there’s not in house editor so you’ll have to restore via ssh) If you also installed dkim-milter, it would have also created a backup file of In the dropdown go to main.rpmsave, virtual.rpmsave and master.rpmsaveĪnd copy/paste each one to their respective default file. Now go back to “Postfix Mail Server” settings and go to “Edit Config Files” It will say that it’s not installed, click the install button for it to reinstall
Go to your Webmin CP -> Servers -> Postfix Mail Server This indeed happened however luckily it created a backup for the main, virtual and master configuration before uninstallation. Now you may have noticed that during the uninstall that postfix was also uninstalled along with mariadb 5.5. The Mysql area will be able to read the config file. Your mysql service has now been upgraded to 10.2 without issue. (if you happen to use the example, remove the innodb_additional_mem_pool_size line as it’s no longer being used) Restore your my.cnf you made a backup of or use one of the examples in the directory i mentioned above. $ yum install MariaDB-server MariaDB-client (you can always get the default one from /usr/share/mysql)Ĭreate a file in /etc//MariaDB.repo then copy and paste the code below inside it. Next stop and uninstall the current mariadb service:Īlso make a backup of your etc/my.cnf file before you do this. Mysqldump -u root -p -all-databases > database-backup.sql Nginx + PHP-FPM (7.1.8) + Memcahce + Redis + MariaDb 10.2.7įirst before you do anything make a backup of your current database:
0 kommentar(er)
