mysql - How to repair & backup archive table, also stop growing .ARN extension file?

98
March 08, 2018, at 2:10 PM

I have an MySQL table build with archive storage engine. The table have lakhs of records.

I have got disk full and it turned out to be a large .ARN file from an archive table. When I cleared some space, the file continued to grow until the space was consumed.

Right now the .ARN file is over 16GB and it's growing on every insert. The corresponding .ARZ file is just over 8MB.

Also I cannot fetch record from archive table, as the table data is corrupted. When I tried to repair table it says "Incorrect key file for table" which means File system out of space.

But I am left with no disk space, so I have to repair and backup this table on my local machine.

Please guide how can I repair archive table, backup data from archive table and free some disk pace. Also explain why .ARN file keeps growing on every insert.

READ ALSO
MySQL query to gather incorrectly stored data

MySQL query to gather incorrectly stored data

I have recently taken over a email campaign project and need to generate a report for the customerHowever the data has been stored very strangely

142
mysql inserts int instead of doubles

mysql inserts int instead of doubles

i have table with a row duration of type double(i also tried decimal and float with same result)When i now insert a row with

142
SQL - Host your own MySql or PostgreSQL server [on hold]

SQL - Host your own MySql or PostgreSQL server [on hold]

I am new in deploying things on the webSo, I've thoroughly research the net about hosting my own MySQL and PostgreSQL Server, but I was redirected to cloud services

156