mysql restart, tables gone

CentOS 4.2, kernel 2.6.9-22.0.2.EL, MySQL 4.1.15

Some days ago I did some simple changes to my.cnf, and then issued "service mysqld restart" to make the changes effective. MySQL restarted fine, but I soon discovered a serious problem: Some tables had simply disappeared?

On further investigation the tables .MYD -files had simply vanished.

Luckily these where tables not updated that frequently, and I had an 4 hour backup that did just fine.

The ting that is bothering me is how could this happen? No error-messages, nothing, just an innocent restart of the server. The tables didn't just become corruptet, MySQL actually deleted the data-files? Thats pretty serious in my eyes. Ok, service restart could possibly corrupt something, but MySQL shouldn't just delete the data and pretend nothing happened should it?

So, how could this happen, and how can I make sure it doesn't happen again? As of now, I'm pretty nervous doing any more restarts.

 

 

 

 

Top