1. recovery
vi /etc/my.cnf.d/mariadb-server.cnf
///
[mysqld]
///
innodb_force_recovery = 4 # 0
///
rm /var/lib/mysql/mysql.sock
mkdir -p /var/run/mariadb
chown mysql: /var/run/mariadb/
systemctl start mariadb.service
mariadb-check -u root -pPassw0rd --all-databases --auto-repair --verbose
Processing databases
cid
cid.hosts OK
hadb004
hadb004.event_data OK
hadb004.event_types OK
hadb004.events OK
hadb004.migration_changes OK
hadb004.recorder_runs OK
hadb004.schema_changes OK
hadb004.state_attributes OK
hadb004.states OK
hadb004.states_meta OK
hadb004.statistics OK
hadb004.statistics_meta OK
hadb004.statistics_runs OK
hadb004.statistics_short_term OK
information_schema
insdb
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats 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.transaction_registry OK
performance_schema
sys
sys.sys_config OK