General Community > Scripting Help

Corrupted mysql tables ...

<< < (2/2)

[Unknown]:
Odd... is your server being restarted often?  Windows or linux?

-[Unknown]

fractalbit:
We recently moved to a faster and  more stable server that has 9 days to be restarted (info from phpinfo), which is basically from when we moved. But during this period of 9 days the tables have been corrupted 2 times. One time was the table that hold the data for the photos and repairing it we lost 12 records. The other was the table that hold the photo ratings and i had to contact the support to restore it.

[Unknown]:
Hmm... that's crazy.  How often is this page accessed?

I think you have bigger problems than the code... something is causing the tables to get corrupted.  In my experience, this happens primarily if MySQL is shutdown unexpectedly.

Have you tried running a ANALYZE, OPTIMIZE, and REPAIR on all your tables?  You may even want to ANALYZE them daily.

-[Unknown]

Navigation

[0] Message Index

[*] Previous page