The Ultimate Guide to High Availability with MariaDB

Corrupt MySQL Database Tables

Hello, after the migration from MySQL to MariaDB, several tables in the mysql database got corrupted. I can delete those tables and manually create them using this article but there I have a doubt: Those tables need data or can be empty (at the end of the question will add the "in use" or corrupted tables. Also, is there a .sql file from this database? It will be safer to do this using an .sql than manually adding the tables one by one. If there is one, let me know please.

Here are the corrupt tables:

engine_cost gtid_executed help_category help_keyword help_relation help_topic innodb_index_stats innodb_table_stats plugin servers server_cost slave_master_info slave_relay_log_info slave_worker_info time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type

Answer Answered by Daniel Black in this comment.

Revisit the way you conducted the migration. The tables you mentioned are all system tables of MySQL.

Recommend going a mysqldump of the user data and installing this into a fresh MariaDB instance and use tools like https://sqlines.com/mysql-to-mariadb to smooth over any data SQL differences.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.