Axel Schwenke wrote:
> Jerry Stuckle <jstucklex@attglobal.net> wrote:
>> Beyza wrote:
>>> Hi Everyone,
>>>
>>> I have some problems with raw mysql data such as MYD MYI frm files. I
>>> got some files from my friend and he does not know which version use
>>> those files. I have installed 3 different mysql version but i still
>>> get "....was created with a different version of MySQL and cannot be
>>> read" error. How can i determine version or convert to sql files?
>> In general you can only use the files themselves if the version and OS
>> are exactly the same.
>
> No. And No.
>
>> There may be some exceptions, but don't count on it.
>
> 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.
>
> Table version is in the .frm file normally.
> Here: http://dev.mysql.com/doc/internals/en/index.html
> is some background information.
>
>
> So to use an unknown MyISAM table,
> - get latest MySQL server
> - run myisamchk on the table, if that succedds
> - put table in datadir and access it
>
>
> 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/

Axel,

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.

Now I understand when you go down in version it might not work. But
going to later versions doesn't always work, either.

Backup/restore always works (except for things like changes in the
password algorithm).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================