Tim Smith wrote:What made you think you could do this?> OK, what is supposed to happen in this situation? We have a mysqldump of a
> database. We restore it on two different mysql servers, one running 5.0,
> one running the latest in the 4.0.x series. MyISAM tables on both.
> We then stop both servers, and do myisamchk on each. They are both happy.
> We then copy the MYI and MYD files from each server to a temp directory on
> the other, and check them again, so that we are using the 5.0 myisamchk to
> check tables created by the 4.0 server, and vice versa.
Why would you think so? It's never been doented to be the case.> Each reports that the tables have bad indexes and are corrupt.
> I thought that MyISAM tables were binary compatable across versions of
> MySQL?You just can't copy files from one server to another.>
> Does this mean that when settup tion from a master to a slave, where
> the slave is running a later version of mysql, that after taking the
> snapshot on the master, it needs to by myisamchk'ed on the slave before
> being used?
Remove the "x" from my email address
JDS Computer Training Corp.