Unable to restore database backup InnoDB: Error: Table "mysql"."innodb_table_stats"

Symptoms

• Unable to restore a database backup:

  [2017-08-09 14:18:55] ERR [panel] Cannot save cli call statistic DB query failed: SQLSTATE[HY000]: General error: 1036 Table 'CliCallsStat' is read only, query was: INSERT CliCallsStat (`util`, `command`, `lastExecutionDateTime`) VALUES (:util, :command, now()) ON DUPLICATE KEY UPDATE `count` = `count` + 1, `lastExecutionDateTime` = now()

• The command plesk repair db returns the following error:

  InnoDB: Error: Table "mysql"."innodb_table_stats"

• MySQL 5.6 is used.

Cause

The table innodb_table_stats is corrupted.

Resolution

1. Log in to the server via SSH.

2. Remove corrupted tables:

   # rm -rf /var/lib/mysql/mysql/innodb_table_stats

3. Connect to the MySQL server:

   # plesk db

4. Switch to the mysql database:

   MYSQL_LIN: mysql> use mysql;

5. Recreate innodb_table_stats table:

   MYSQL_LIN: mysql> CREATE TABLE `innodb_table_stats` (
   `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
   `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
   `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `n_rows` bigint(20) unsigned NOT NULL,
   `clustered_index_size` bigint(20) unsigned NOT NULL,
   `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
   PRIMARY KEY (`database_name`,`table_name`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;