Hi,
I recently did a backup of an MySQL ARCHIVE (engine) table and I am trying to restore this table on another server. Basically, the backup process was to copy the .ARZ and .frm and move the files on the new server. Then I chmoded the files (mysql:mysql) and set the permissions (now it appears 777 since I wanted to make sure it was not a permission issue)
-rwxrwxrwx 1 mysql mysql 761939854 Oct 5 12:03 events_2009.ARZ
-rwxrwxrwx 1 mysql mysql 8895 Oct 5 12:03 events_2009.frm
.... when I try to query this table on the new server, I get this error:
mysql> select * from events_2009 limit 0,10;
ERROR 1017 (HY000): Can't find file: 'events_2009' (errno: 2)
.... ANALYZE TABLE says the table is "corrupt"
mysql> analyze table events_2009;
events_2009 | analyze | Error | Can't find file: 'events_2009' (errno: 2)
events_2009 | analyze | error | Corrupt
.... REPAIR TABLE gives me the same thing as ANALYZE TABLE
mysql> repair table events_2009;
events_2009 | repair | Error | Can't find file: 'events_2009' (errno: 2)
events_2009 | repair | error | Corrupt
Any idea why I can't restore the table? Is it related to the files permissions? In case my backup process is the problem, what is the correct way of doing a backup/restoring an ARCHIVE table with MySQL?
Thank you for your time!