Hello,

my host has just changed servers and also updated mySQL. Well, the database files that I zipped using telnet have the endings (for one table) .frm / .ISD / .ISM

Well, the .frm files seems to be the general layout, but the other two file endings aren't identical with the ones I locally have and in phpMyAdmin (and on the web) no data is being retrieved. The .ISD file seems to count the number of entries while the .ISM file contains the actual data.
In phpMyAdmin the correct number of entries is shown.

Anyone knows how to update those files?

Thanks,

Stephan

    sorry, have made a type in my email address...

    Stephan

      this has worked for me before. even between different minor versions of mysql.

      1) stop mysql

      2) move the .frm, .isd, & .ism files into the database folder under the mysql directory.

      3) set the permissions on the files. make sure only mysql has rwx access to the files and database folder.

      4) start

        Write a Reply...