I'm looking after a call centre (center for American fellows :) ). We recently installed VoIP based telephone system.
One of many components of the new system is a logging software. The software provider supplied their own "server" for this purpose. In fact, the machine has Windows 10 Pro installed rather than a server OS.
The database technology, behind the logging software itself, is MySQL. Recently, two of the .ibd files (MySQL tables) have been corrupted. The support spent ages on the server and, although, they haven't fixed the issue, they came up with the theory that this happened during the Windows update.
The system is so new that I haven't got to sorting the backup solution for it yet, so, according to the support, we lost the data.
Although, this is not business critical, it is still painful.
As far as I understand Windows creates a restore point before each update. My question is - will the Windows restore activity return the .ibd files to the previous state?
Thanks all for your input.
: Phalcon\Cache\Backend\File::save(): Only 0 of 33061 bytes written, possibly out of free disk space in /home/queryxchang/public_html/public/index.php on line 37
Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-2-1275063-fixing-corrupted-ibd-file-mysql-table-with-windows-restore- could not be written