'aria_chk: error: Page 178675712: Got error: 176 when reading datafile
I want to move the Area tables to another server. To clear the transaction id's I run the command: aria_chk --zerofill *.MAI
But on some tables I get an error: aria_chk: error: Page XXX: Got error: 176 when reading datafile Aria table 'tablename' is corrupted. Fix it using switch "-r" or "-o"
Such a table is marked as corrupted by aria_chk. I tried "-r", "-o" and other recovery methods, making duplicate tables, but I always get this error. If you move such tables to another server, MariaDB will restore them. It takes a very long time because the size of tables is up to 10Gb. How can I clear the transaction id's and move the big tables so that another server doesn't run the table recovery procedure?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|