0

Hello,

Please as at this morning everything was fine, but all of a sudden all data record wiped off from 3tables in my database, now my client can't find records.

Am using MYSQL, Visual Basic.

Thanks.

2
Contributors
3
Replies
12
Views
2 Years
Discussion Span
Last Post by cereal
0

Thank Cereal, I will try this, but how did it happen, will I always lose records like that using MYSQL?

1

No, it shouldn't happen, check the database error log to find some information:

It can happen if the database executable (mysqld) is killed while writing data to a table or for an unexpected shutdown of the computer. However there are many things to consider depending on the used engine, here are few links to InnoDB and MyISAM but you should check the documentation for each specific engine in use:

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.