0 down vote favorite We have damaged disks on the server and partially lost data. Backup of the database was not the most relevant, so it was decided to restore the database from the .myd, .myi, .frm files.
Since the tables were MyISAM, the restoration itself is simple. We stopped mysql, copied the files to the directory, started mysql.
As a result, the database went up, at first glance, everything is fine, but it turned out that some of the records in different tables (inside one database) are missing. CHECK TABLE thus does not show any problems. There are no strange glitches, no damaged or erroneous records, that is, it looks like it's all right.
Accordingly, in connection with this, two issues are ripe:
Is the database recovery process correct? In theory, there are no difficulties, copied the files and is ready. But, maybe, there are nuances?
In general, how could such a situation turn out? Judging by the fact that everything was restored without any errors, we can conclude that these database files were not damaged on a defective disk. But why and where then did the records disappear? Maybe still there is an opportunity to get them somehow? Just in my understanding, if the file was corrupted, nothing would be restored. And then it turns out that just a few hundred / thousand records were missing. (Total DB on 100k + records)