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

MySQL Enterprise thingy

It's been a weird thing when you install MySQL server especially the one that is 'enterprise' version is not working with your PHP. That is the problem that my friend and I facing today. Since PHP require php-mysql extension to connect to MySQL server but php-mysql is only work with mysql-server from the Repos (Redhat/Centos). 1) Remove default mysql-server/php-mysql 2) Install MySQL Enterprise 3) Dependencies conflict occur + headache + install php-mysql shell> yum install php-mysql Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql --> Running transaction check ---> Package mysql.x86_64 0:5.0.77-4.el5_4.2 set to be updated --> Process...
2 comments
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

Masalah unetbootin di Mac untuk USB boot

Masalah unetbootin kadang jadi kadang tidak, so solution yang cepat ialah gunakan dd. Kenal pasti USB disk kita dia mac dengan arahan : Yusof$ diskutil list /dev/disk0 (internal, physical):    #:                       TYPE NAME                    SIZE       IDENTIFIER    0:      GUID_partition_scheme                        *240.1 GB   disk0    1:                        EFI EFI                     209.7 MB   disk0s1    2:          Apple_CoreStorage Macintosh SSD           239.2 GB   disk0s2    3:                 Apple_Boot Rec...
Post a Comment
Read more