MySQL Forums
Forum List  »  InnoDB

Re: Mysql 8.0.21 [ERROR] [MY-011906] [InnoDB] Database page corruption on disk or a failed file read of page
Posted by: Peeraapong Patjaararunglert
Date: June 28, 2022 08:46PM

Peter Brawley Wrote:
-------------------------------------------------------
> Did you follow suggestions at
> https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html?
>
> What's a "cool backup"? How did you "delete"
> databases? Do you have a logical backup, ie done
> with mysqldump?


Thank you for you advise
i did https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html?
the mysql database started in innodb_recovery > 0
i had solved this problem
Step 1 : delete table and restart mysql in normal (innodb recovery = 0) -> Failed to start mysql
Step 2 : try to disable partition table (the log showed in oper_job that that was partition table) and restart in normal mode -> failed to start
Step 3 : drop all databases in this mysql and restart in normal mode -> failed to start mysql

====================================
i restore from VM backup before the log time had alerted in 27 Jun 2022 17:07

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.