What is failsafe way to migrate ? Both database are on CentOS 7 different servers and latest versions of database.

  • Firstly backup your DB structure (everything except data) on MariaDB using mysqlbackup and then try to restore it on MySQL. It will show does some specific for MariaDB options are present, and if so, you must investigate does it is possible to adapt the backup for to import onto MySQL. If you find success way then do the same but with DB data (or backup data only and import it into previously imported structure). – Akina Sep 19 '19 at 11:36
  • I will update here once I attempt this in off hours. – Tim Sep 19 '19 at 12:00
  • Use the source's (ie, MariaDB's) mysqldump. That will probably avoid incompatibilities in the dump file. In the other direction, the keyword VISIBLE has tripped up a number of DBAs. – Rick James Oct 3 '19 at 23:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.