Lost data when computer shout down

[ESMHOA]

hi
i have problem that is
Lost data when computer shout down
i mean when my program working and every thing is OK then the computer broken down because the power is OFF ,
then put the computer ON but the data is lost
all the tables is free
i'm using MYSQL database
Please what's the promlem?

[ertank]

Hello,

I strongly doubt that UniDAC is the problem here. You might want to ask this question in MySQL forums. I do not use MySQL myself. However, a google search has a lot of links that might help you. I have a feeling that InnoDB has some known problems about lost data after reading so many questions about it in search results. Below are some results.

1- no solution, but similar problem: https://forums.mysql.com/read.php?22,391691,391691
2- there is a solution suggested: https://dba.stackexchange.com/questions ... fter-crash
3- there is a solution suggested: https://twindb.com/data-loss-after-mysql-restart/
4- here suggestion is to downgrade to certain version: https://stackoverflow.com/questions/177 ... -restarted

Regards,
Ertan

[ViktorV]

Unfortunately, we cannot reproduce the issue using the information provided by you and you are the only user who contacted us with a similar problem. To understand the cause of the issue, we need a test sample, in which the issue is stably reproduced. As soon as we get such a sample and if the issue cause is due to our product code, we will try to fix it in the shortest possible time.
Therefore, please compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html including the scripts for creating database objects.
Also, please specify the used MySQL version and the exact steps to reproduce it.

[isysoftware]

I have had the same problems with MySql

[ViktorV]

As we wrote earlier, we could not reproduce the issue. It occurs as a result of some specific conditions that we do not know, and, unfortunately, the sent log does not provide us with the information about these specific conditions. Therefore, we are waiting for the sample, reproducing the issue, for its investigation.