Corrupt table can cause a column to go missing?

Unfortunately I have had my mySQL database crash three times during the past month. Today it caused a column I added two days ago to completely go missing. Is this normal?

And what is the reason that running a “repair” on a table doesn’t actually repair it? I wish I knew what was causing this to happen.

Thank you.

Are there any entries in the error logs for PHP, MySQL or your webserver (presumably Apache) that are around the time that the database is crashing which might indicate why it’s crashing?

How often are you running backups? If you are getting crashes then backing up more often may be worthwhile.

In my experience, an often crashing MySQL database is a sign the hard disk is about to fail completely. If repairing the table doesn’t work, then the damage is serious. Have you spoken to your hoster about it?


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.