Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
5 years, 1 month ago
. This question needs to be more
. It is not currently accepting answers.
Want to improve this question? Update the question so it focuses on one problem only by editing this post.
Now, the mysql version is
5.1.I plan to move to mariadb
source to update databases.
Based on MySQL Upgrade Strategies,
Upgrading to the latest release is recommended before upgrading to the
mysql 5.1->mysql 5.7->mariadb 10.2
mysql 5.1->mariadb 5.1->mariadb 10.2
Which way is better(less data loss)?
Apr 21, 2018 at 14:28
We can't do anything without a problem except point you to the official information,
Generally the further you are from an original fork the more complexities you'll encounter in the migration. Therefore the earlier the version of MySQL the fewer features of MySQL that are MySQL-specific that you'll have to contend with. Upgrading to a newer of MySQL before the migration to MariaDB is likely to make your job harder.
Apr 22, 2018 at 2:18
Evan Carroll Evan Carroll
60.4k 44 44 gold badges 224 224 silver badges 455 455 bronze badges
It's very probable that next sequence would be way more fast and painless comparatively to the software upgrading:
mysqldump all the databases
export all accounts with permissions
import databases and accounts
Apr 22, 2018 at 22:21
4,234 15 15 silver badges 13 13 bronze badges
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only
sourcecommand to import the dump if it's a big database as it prints the results of each statement to the terminal, so might be slow. Instead, if you're on Linux/Unix, run something like this from the Linux/Unix shell:
mysql name_of_database < dumpfile.sql > import.log
Upgrading to the latest release is recommended before upgrading to the next version