Comments - The database (mariadb) is affected by the restoration of windows
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
So I tried the system restore. Yes, the innodb tables will go back to the past point. first there is an "Undo" in the UI, it seems like it would create a volume shadow copy before doing system restore. You can explore the content with "System Restore Explorer", and I found the pre-system-restore .ibd files there.
Second point is that the user has to regularly do backups, himself of the database, if the data is valuable, rather than not play with Windows System restore. And store them on network location, in the cloud, or somewhere outside of the box, for the case of emergency.
I bet the developers for SQLServer and Postgres did exactly as much as we for system restore, namely nothing. On some arbitrary reason, this questionable tool decided to handle .IBD files specially, so the options are "complain to Microsoft" , or "tell your customers not to use it, to create database outside of system disk, to do their own emergency backups" etc.