Skip navigation links

MySQL Forums :: Archive Storage Engine :: How to enable ARCHIVE Engine in 5.0.77?


Advanced Search

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


Subject Views Written By Posted
How to enable ARCHIVE Engine in 5.0.77? 2789 Shashidhar Y 11/28/2011 11:21PM
Re: How to enable ARCHIVE Engine in 5.0.77? 1313 Toomula Nanda kishore 12/08/2011 06:06AM
Re: How to enable ARCHIVE Engine in 5.0.77? 1630 Shashidhar Y 12/12/2011 05:02AM
Re: How to enable ARCHIVE Engine in 5.0.77? 1505 Toomula Nanda kishore 01/04/2012 12:01PM


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.