0

Hello,

I wonder what's the difference between *.frm, *.MYD, *.MYI ?

I have tried to transfer filelogs.frm to another xampp server and it works on one machine while it doesn't on the other one.

Do I have to have all of the extension in order for the xampp server to works?

Thanks in advance.

2
Contributors
1
Reply
15
Views
3 Years
Discussion Span
Last Post by cereal
0

It's probably due to this:

If you are using MySQL 3.23 or later, you can copy the .frm, .MYI, and .MYD files for MyISAM tables between different architectures that support the same floating-point format.

And:

If you want to move applications to another machine having a different architecture or operating system than that of the current machine, you should not try to move a database by simply copying the files to the other machine. Use mysqldump instead.

Source: http://dev.mysql.com/doc/refman/4.1/en/copying-databases.html

So it depends on the CPU of these machines:

As suggested by the documentation use mysqldump and mysqlimport:

Bye!

Edited by cereal

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.