Public bug reported: MariaDB is supposed to be a drop-in replacement for MySQL. However, version 10 does not handle the upgrade process correctly from MySQL 5.7 in Ubuntu 16.04. Upgrading causes a total loss of data.
The version I experienced the issue with is mariadb-server 10.0.28-0ubuntu0.16.04.1. However, version 10.0.x and 10.1.x will always have this problem. MariaDB bug that was opened to better handle MySQL serve MySQL 5.7.x since they changed their structure: https://jira.mariadb.org/browse/MDEV-11170?page=com.atlassian.jira.plugin.system.issuetabpanels %3Acomment-tabpanel&focusedCommentId=90592 I can't believe this was released as a stable Ubuntu package. The package should prevent installation if upgrading from MySQL 5.7 since all of the original databases and data are lost from the upgrade. I suggest the package is either updated to 10.2.x (beta support for 5.7) or fails and prevents data loss during installation if MySQL 5.7 server exists. ** Affects: mariadb-10.0 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1656393 Title: MariaDB Fails to Handle MySQL 5.7 Data Changes - Upgrade Results in a Complete Loss of Databases and Data To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1656393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs