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/