Member Avatar for davy_yg

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
  • 158 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.