I am running MariaDB 10.2 on Windows and I had some damage to my server's hard drive that ruined some innodb tables. Unfortunately, this also affected the backups, so I'm trying to dump the tables and restore them.
The problem is that, even with forced recovery set to 6, the server will be blocked when it reaches a damaged row. Dumping the table with asc and then desc worked for one table, but not for another and any attempt to skip the row with the limit and the compensation is still blocked.
I saw that there was a
innodb_pass_corrupt_table_action = salvage Option in 10.1, but it is in disuse and is ignored with 10.2. Is there a similar configuration for 10.2? Are there other options to force MySQL to dump the tables? Thank you!