0

MySQL Server Version is 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

I want to switch over to MariaDB, but I can't get MariaDB to accept the existing database. I also tried doing a slow shutdown with InnoDB Engine and importing the database as .sql created with mysqldump.

The import of the .sql fails because the mysql.user table is different and I need to keep passwords, users and grants.

After migration I am getting this error:

Fatal error: mysql.user table is damaged or in unsupported 3.20 format.

This is the final error before the DB fails to start.

Also mysql_upgrade does not work.

How should I perform the migration?

Edit:

This didn't work either (Official Bug Report).

Improve this question
2
  • 10.what? Perhaps 10.2 is more likely to work.
    – Rick James
    Commented Jan 18, 2017 at 21:09
  • what if you dont import mysql database and just import user defined database ?
    – simplifiedDB
    Commented Jun 23, 2017 at 9:45

1 Answer 1

Reset to default
0

Fixed this by dumping the MySQL database and reimporting it with MariaDB.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.