Reclaiming space from ISMAP files

[Guest_imported]

I have a troublesome situation. I am supporting an environment that accumulates large amounts of data in a MySQL database. As a result, the data files grow rather large. I've purged the old data, and need to find some way of optimizing the data files so that they are not holding space for all of the deleted data.

Unfortunately, the MySQL implementation is 3.22, and the data files are ISMAP; furthermore, due to red tape, etc., upgrading to MySQL 3.23 and converting the files to MyISMAP format is not a short term option (not that I'd know how to reclaim space for those types of files either). Does anyone have information on how I'd go about accomplishing this task?

Thanks,
Cyran0

 

[Guest_imported]

My apologies, I meant ISAM files... geez!

 

[TimSNL]

I'm not exactly sure but you should check out the isamchk utility.

isamchk *.ISD (standard command)
isamchk -r *.ISD (normal recovery operation)

Check out the manual for the isamchk command before using it and see what you think s-). It may help.