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.


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

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:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.