MySQL Forums
Forum List  »  MySQL Workbench

Tables and database crashing, rows being deleted
Posted by: Ondřej Suchomel
Date: February 09, 2024 01:59AM

My MySQL tables and whole MySQL server started few months crashing.

After some time after I realized that some rows in almost all tables started missing (sometimes few a day, once 15000 rows at once in one table). In some tables were generated strange numbers.

I reinstalled system. DB restored copying data files into data folder whole database (I started to backup DB by copying data folder about 2 years ago with no problems).

I realized that some values in rows are being changed!

I am repairing crashed tables almost every day using mysql function or phpmyadmin.

I run DB on 7 yeas old SSD used at HP Z240 as a CAD machine.

Can someone help?

Windows 10, EasyPHP 14.1., Apache, phpMyAdmin, PHP and Python using MySQL. MySQL version 5.6.15. No issues with free space on drive.

Options: ReplyQuote

Written By
Tables and database crashing, rows being deleted
February 09, 2024 01:59AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.