Axel Schwenke wrote:
> Jerry Stuckle <jstucklex@attglobal.net> wrote:
>> Axel Schwenke wrote:
>>> It is one of the features of MyISAM that data is stored platform
>>> independent. Also MyISAM is backwards compatible. Newer Server can
>>> always read the older versions. There may be issues with indexes,
>>> but reading, especially exporting data should always work.
>
>> It's a good concept. But it doesn't always work in practice.
>> Export/Import always works. I've often had problems with copying the
>> files, especially between OS's and versions.
>
> Since the platform independence is an important feature of MyISAM, I
> would like to know the details.
>
I wish I could give you exact versions, but I can't - it's been close to
a year ago that I had a customer with this problem. But they were
trying to go from a 3.x version to 4.1.x. Copying their files over
didn't work (yes, the MySQL was down when they tried). But backing up
and restoring the database worked fine. IIRC, one system was linux and
the other Windows, but I'm not sure which was which (or even if I'm
correct on this). And I'm sure I told them to FTP the files in binary
mode (just because I've seen that screw things up too often).
I never reported it because they didn't want to spend any time
troubleshooting the problem - they just wanted it to work. I didn't
push it because I wouldn't necessarily expect it to work.
Sorry I don't have more details - but as I said, it's been quite a while.
>> Now I understand when you go down in version it might not work. But
>> going to later versions doesn't always work, either.
>
> There may be problems if you try to open files from a *very* old MySQL
> version on a recent server. However, for upgrading MySQL you usually
> don't need to unload/load your data but just upgrade the executables
> and run mysql_upgrade (that uses myisamchk behind the scenes).
>
>> Backup/restore always works (except for things like changes in the
>> password algorithm).
>
> ACK on that. SQL dumps are better in most cases.
>
>
> XL
> --
> Axel Schwenke, Support Engineer, MySQL AB
>
> Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
> MySQL User Forums: http://forums.mysql.com/
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================