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).

  • 10.what? Perhaps 10.2 is more likely to work. – Rick James Jan 18 '17 at 21:09
  • what if you dont import mysql database and just import user defined database ? – Ankit Kapoor Jun 23 '17 at 9:45
0

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

Your Answer

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

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