Re: Rescuing OLD ISAM database tables

On 24/02/15 19:02, Henry Hartley wrote:
> I have recently had the need to recover some data that was archived
> in the dark and distant past (2003). Unfortunately, while the files
> were easily found and restored to disk, they are in ISAM format and
> cannot be read by MySQL (version 5.1.x on CentOS 6.6). I'm trying to
> figure out my best approach.
>
> My thought was to install some old version of Linux that still has
> MySQL pre-4.1 onto some spare machine, copy the files onto that and
> convert them to MyISAM, then copy them back to my main server, where
> I assume they should just work.
>
> Any other options that anyone can think of?
>
> Any suggestions as to what version of Linux would be easiest? Looks
> like Fedora 4 and CentOS 4 already had MySQL 4.1. Fedora 3 has MySQL
> 3.23.58. I think 3.23 is when MyISAM was introduced. Should that work
> for this purpose?
>

http://dev.mysql.com/doc/refman/4.1/en/isam-storage-engine.html

seems to have most of the info you need

-- 
Everything you read in newspapers is absolutely true, except for the
rare story of which you happen to have first-hand knowledge. – Erwin Knoll