Mysql table records truncated suddenly

[adebayo23]

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.

[cereal]

Hi, use backups or, if enabled, the binary log:

• https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
• https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html
• https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html

[adebayo23]

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

[cereal]

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

• https://dev.mysql.com/doc/refman/5.7/en/error-log.html

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:

• https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
• https://dev.mysql.com/doc/refman/5.7/en/myisam-table-problems.html
• Other storage engines: https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html