Recommended ways to upgrade MySQL to MariaDB

ccto

Verified User
Joined
Feb 24, 2005
Messages
275
Location
Hong Kong
Hello Everyone,

May I know -

Q1) What is the recommended ways to upgrade MySQL 5.5 x64 to MariaDB 10.1 x64?

(Shall I copy /var/lib/mysql/ to MariaDB 5.5 db host first, then ./build set mariadb 10.0; ./build mariadb ; then ./build set mariadb 10.1; ./build mariadb )

Q2) Similarly, what is the recommended ways to upgrade MySQL 5.6 x64 to MariaDB 10.1 x64?

Q3) Is MariaDB 10.0 similar to MySQL 5.6?

Q4) Is MariaDB 10.1 similar to MySQL 5.7?

Thank you very much for your information.

Regards
George
 
1. Create a copy/backup of /var/lib/mysql
2. Edit /usr/local/directadmin/custombuild/options.conf and set the mariadb version you want to use.
3. Run /usr/local/directadmin/custombuild/build mariadb
4. You're done!
 
If I use these steps do I need to recreate/import the databases? Or will it automatically import/work with my existing databases?
 
Custombuild will take care of the existing databases, so no need to do import/export of them.
 
Q3 and Q4 - most of the things are compatible. But the only fully compatible versions are MySQL 5.5 and MariaDB 5.5. All newer features are not 100% the same and not 100% compatible. You can count them as different projects from MySQL 5.6 and MariaDB 10
 
Back
Top