MySQL Forums
Forum List  »  Archive Storage Engine

How to enable ARCHIVE Engine in 5.0.77?
Posted by: Shashidhar Y
Date: November 28, 2011 11:21PM

Hello guys,

I have got a very big problem on my neck.

we are using mysql 5.0.77 and couple of days back we moved our tables (which have historical data) from MYISAM engine to ARCHIVE. It went well, in fact I see files for these archive table (ARZ, ARM etc.,) in my file system. Things were good.

Couple of days back when we try to do database backup with the script, we noticed some of the table files didn't find by mysql. Diving bit deeper we came to know is all these tables are ARCHIVE tables. But we do see all table related file does exist in database folder. After doing some more investigation we came to know ARCHIVE engine is disabled on this server (This server went for schedule restart just 10 days back).

The "Show engines" command clearly shows below lines

*************************** 7. row ***************************
 Engine: ARCHIVE
Support: NO
Comment: Archive storage engine

also this ...

mysql> show variables like 'have_archive'\G
*************************** 1. row ***************************
Variable_name: have_archive
        Value: NO
1 row in set (0.13 sec)

I don't know how this ENGINE is disabled on the fly. But my goal is to make ARCHIVE table's visible and accessible.

Can any one help me how to enable ARCHIVE engine on my server (5.0.77)?

Options: ReplyQuote

Written By
How to enable ARCHIVE Engine in 5.0.77?
November 28, 2011 11:21PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.