Skip to main content

Upgrading MySQL to MariaDB

Ever since MariaDB exists, I really like to install and test the performance but time consume for my daily work stopped me to try MariaDB, today I plan to update my MySQL server that serve lot of data in and out to MariaDB 10.0 (today latest version :P )

So there's a few step that should be considered before we can proceed further.

1. BACKUP
- Always backup your data at the first place.
- Save it to the proper place so that if anything goes wrong, you can export back your data.

mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql &

If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :)

- Backup your current configuration files

cp /etc/my.cnf /tmp/my.cnf.bak

2. Let's go

If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like

Error: mysql55w conflicts with MariaDB-server-5.5.41-1.el6.i686
Error: mysql55w-libs conflicts with MariaDB-compat-5.5.41-1.el6.i686

You can try my work around :

yum replace mysql55w-libs --replace-with mysql-libs

Proceed with the step below :

https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6

Comments

Post a Comment

Popular posts from this blog

Complete guide to update/upgrade cakephp

This is what people always forgotten. How to update your cakephp to the latest from CLI         phpmamp composer.phar update How to upgrade to 3.* branch     phpmamp composer.phar require --update-with-dependencies "cakephp/cakephp:3.5.*"         ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev)       - Removing cakephp/cakephp (3.4.13)       - Installing cakephp/cakephp (3.5.6)         Downloading: 100% Writing lock file Generating autoload files Done !
Post a Comment
Read more

DirectAdmin - Upgrading MySQL from 5.5 to 5.6

cd /usr/local/directadmin/custombuild mkdir -p mysql cd mysql wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-client-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-devel-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-server-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-shared-5.5.41-1.linux2.6.x86_64.rpm cd .. ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` #after this point, you can't abort rpm -e --noscripts `rpm -qa | grep MariaDB` cd mysql rpm -ivh MySQL*5.5.41*.rpm #ensure it's running. cd .. ./build set mysql 5.6 ./build set mysql_inst yes ./build mysql # confirm mysqld is running. ./build php n
Post a Comment
Read more

FAMPP - Installing MySQL Server

simpler command :) #pkg_add -r mysql51-server from this command it will install mysql server and also mysql client for the server once done we can enable it on boot up by editing rc.conf #ee /etc/rc.conf add this following line mysql_enable="YES" After that we can start the service by this command : #sh /usr/local/etc/rc.d/mysql- server.sh start Then we have to configure our root login for mysql which is by default it is blank. By using a password for the root login it will be more safe to outsider :) #mysql -u root #SET PASSWORD FOR 'root'@'localhost' = PASSWORD('urpasswordhere'); once done try to login using root user #mysql -u root -p Enter password: If that appear then you have successfully configuring your mysql server :)
Post a Comment
Read more