mysql の自動バックアップがWarnings
なんかエラー吐くので、しらべたら、MySQL → MariaDB でしかもバージョンアップが終わってるのにテーブルが古いってことらしい
mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
アップグレードコマンドを叩いてみた
root@acid: # mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair -p Enter password:
そのご、アップグレードする。
root@acid:~# mysql_upgrade -p Enter password: MySQL upgrade detected Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines Checking for tables with unknown storage engine Phase 3/7: Fixing views from mysql Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases epgrec epgrec.rc_reserveTbl OK (略 : データベースのテーブルを全部チェック information_schema performance_schema wp_black wp_black.wp1_commentmeta OK (略 : データベースのテーブルを全部チェック Phase 7/7: Running 'FLUSH PRIVILEGES' OK root@acid:~#
複数回の実行からは保護されてるっぽい
root@acid:~# mysql_upgrade -p Enter password: This installation of MySQL is already upgraded to 10.1.26-MariaDB, use --force if you still need to run mysql_upgrade root@acid:~#
