Comments - Aria FAQ

1 year, 1 month ago Александр Малыгин

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?

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.