The Ultimate Guide to High Availability with MariaDB

Comments - Corrupt MySQL Database Tables

2 years, 3 months ago Daniel Black
Re: Corrupt MySQL Database Tables [Answer]

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.

 
2 years, 3 months ago Renato Carabelli
Re: Corrupt MySQL Database Tables

Hello, thanks for your answer Daniel. I deleted via terminal the corrupt tables and all associated files and then recreated the tables using the instructions in the article. It worked perfectly well, basically is what you suggested.

Thanks for helping.

 
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.