From: Dan Nelson
Date: October 23 2007 7:03pm
Subject: Re: upgrade from 4.1 to 5.0 KO
List-Archive: http://lists.mysql.com/mysql/209644
Message-Id: <20071023190334.GB74788@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 23), Ivan Longhi said:
> I'm running mysql-server on a linux debian box
>
> with apt package system I upgraded mysql server from 4.1 to 5.0 (apt
> automatically execute mysql_upgrade....)
>
> now on my 5.0.32 server almost everything works fine, except for a
> database containing 4 tables: two of them have been upgraded as I can
> see from the extension of the files (.frm, .MYD and .MYI) and I can
> use them without problems, but the other two tables seem not to have
> been upgraded as they are still with 4.1 extensions (.frm, .ISM and
> .ISD).
>
> if I try to operate with them I obtain the mysql error ERROR 1017
> (HY000): Can't find file: 'tablename' (errno: 2) I tried to run
> mysql_upgrade again with --force option but It seems they are not
> considered

You'll need to downgrade to 4.1 and then convert those ISAM tables to
MYISAM, or copy those files to a system that is running 4.1 and do the
conversion there.  ISAM format was deprecated in 4.0 and support was
removed in 5.0.

-- 
	Dan Nelson
	dnelson@stripped