Mysql help ASAP !!

over the past 7 days we have had websites go down 8 or 9 times. It's usually a different website each time, but on one occasion the same customers DB crashed 5 days apart. It seems that mysql is corrupting tables left and right.

Also this may be related or unrelated bu, when we use the "mysql -uuser -ppassword dbname > sqlfile" command it takes our sql file and makes it 0 bytes!

The crash errors we get in the browser when this happens are as follows:

1016 - Can't open file: 'whos_online.MYD'. (errno: 145)


1016 - Can't open file: 'sessions.MYD'. (errno: 145)

Now i am just re-running the sql queries to drop and recreate these crashed tables. However this is no solution. I need to know why this is happening and what can be done about it.

Any help would be greatly appreciated.

shared server
os: linux fedora core 1
mysql: 3.23.58
PHP: 4.3.8

 

 

 

 

Top