Quote:
Originally Posted by Michael01
I had a client uninstall MYSQL50 and delete the folder that housed the Data base files. When we recovered the deleted folder, we found that some tables had not been updated. After further investigation, we found that back-ups were not complete because MYSQL was running during the back-up thus not copying all the files to the DB.
Is there a way to recover the files that were held in MYSQL and not copied to the folder were the DB files were located? The client was copying the entire C: drive of the machine in question. Can we restore, and if so, will we have all the files that were being held in Mysql50?
There are two situations that I can think of that would actually loose data as you describe:
1) Transactions being processed that had not yet been COMMITed
2) Temporary tables in memory, table TYPE = memory.
In both cases, I believe that that data is gone forever.
Otherwise, MySQL will write the tables at the time of the query and the question becomes "When was the backup made?". INSERTs/UPDATEs performed between backups will also be lost.
