MariaDB Error Column last_update in table “mysql”.”innodb_table_stats”…

Issue: After stepped updates from MariaDB 10.0 to 10.3, the following error is displayed (in the error log): InnoDB: Error: Column last_update in table “mysql”.”innodb_table_stats” is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). When this is a cPanel/WHM powered server. It can happen while updating from a previous database, and … Read more

Fixing Corrupt InnoDB Tables

Issue: CentOS 7.x server using cPanel. Admin receives alert email containing the following example: cPanel & WHM has determined that the following database tables are corrupt: Database Error mysql mysql.gtid_slave_pos Error : Unknown storage engine ‘InnoDB’ error : Corrupt mysql.innodb_index_stats Error : Unknown storage engine ‘InnoDB’ error : Corrupt mysql.innodb_table_stats Error : Unknown storage engine … Read more

BlogLogistics