>> i've a running 4.0 Mysql DB (A) and want to upgrade to 5.0 on Etch (B).
>> Because of upgrading the hardware also (new Server), i rynced the
>> mysqldatadir from A to B.
>> B is coming up properly, i run all the scripts recommend by the manual,
>> but i have three tables, that have now status "already up to date" but
>> if i check this tables i got the message "use Repair". I did this, but
>> with no success (still "already up to date")
>> The strange thing is, that the most tables have the same structure, only
>> three from about 50 have this problem.
>> Is this a known problem?
>
> that is not a known problem. if your tables are myisam, better run myisamchk
> (check all the switches/parameteres it takes). and then see what happens. another
> step would be to dump the tables into a text file and drop the tables and recreate
> from scratch and then load the data. but mostly myisamchk should work.


Hi,
i checked the tables already with myisamchk also with the same result.
Even with -e (and others i tried) i got no message about repairing any
problems. The errormessages that i got seems to say, that the tables
need to be upgraded. Is it possible to see, which version a table have?

I hope i can avoid dumping - deleten and reimporting the tables because
the B is set up as a slave for A, so i can do some select test to look
if there are any side effects with my applications and have already an
up to date dataset on B to switch it any time quickly productive (and
shut down A)

Any hints?

Thanks
Daniel