Crashed site
After a Windows update the Mysql (MariaDb 10.4.8) my Xampp installation wouldn't start up and gave as error message "Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.#
# files".
When I do so I get the long list of messages shown below. After finishing it I can start mysql but I cannot use it as the user/password combination is no longer recognized. What can I do to get out of this situation?
Output of aria-chk: mysql.db info : Wrong CRC on datapage at 1 info : Wrong CRC on datapage at 2 info : Wrong CRC on datapage at 3 info : Wrong CRC on datapage at 4 [Removed entries for 5 to 520] info : Wrong CRC on datapage at 521 info : Wrong CRC on datapage at 522 status : OK mysql.event OK mysql.func OK mysql.global_priv warning : Number of rows changed from 0 to 6 status : OK mysql.gtid_slave_pos note : The storage engine for the table doesn't support repair mysql.help_category warning : Number of rows changed from 0 to 40 status : OK mysql.help_keyword warning : Number of rows changed from 0 to 475 status : OK mysql.help_relation warning : Number of rows changed from 0 to 1059 status : OK mysql.help_topic warning : Number of rows changed from 0 to 529 status : OK mysql.index_stats OK mysql.innodb_index_stats note : The storage engine for the table doesn't support repair mysql.innodb_table_stats note : The storage engine for the table doesn't support repair mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv warning : Number of rows changed from 0 to 1 status : OK mysql.roles_mapping OK mysql.servers OK mysql.slave_master_info note : The storage engine for the table doesn't support repair mysql.slave_relay_log_info note : The storage engine for the table doesn't support repair mysql.slave_worker_info note : The storage engine for the table doesn't support repair 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 note : The storage engine for the table doesn't support repair
Comments
Comments loading...
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.