Help! My database really is corrupt.

[dougnyc]

This is what I get when I try loading my site:

 

Warning: open(/tmp/sess_2020eb9f0190036b21c72bba970e0d7e, O_RDWR) failed: m (69) in /usr/local/etc/httpd/vhosts/www.quickzaps.com/htdocs/catalog/includes/functions/sessions.php on line 67

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

delete from whos_online where time_last_click < '1039112229'

[TEP STOP]

 

It has happened before and the solution was to run "repair table customers" in mysql.

 

Now when I do that I get this:

 

SQL-query

 

SQL-query?:?[Edit]

repair table customers

 

Table Op Msg_type Msg_text

quickzaps.customers repair error 69 when fixing table

quickzaps.customers repair status

 

When I view that database in PHPMYADMIN I can see that it's "in use" and I can't repair it with "repair table customers".

 

The two tables that are in use are customers and address_book.

 

What can I do to repair these tables?

[dougnyc]

Table Op Msg_type Msg_text

quickzaps.customers check warning Table is marked as crashed and last repair failed

quickzaps.customers check warning Size of indexfile is: 6144 Should be: 4096

quickzaps.customers check error Can't read indexpage from filepos: -1

quickzaps.customers check error Corrupt

 

How can I repair the table when the repair command fails?

[burt]

Surely you have a full backup of your database, if not :oops:

 

Remove all of the tables fully, and then re-install your from your backup. Should take no more downtime than a few minutes using PHPMyAdmin.

 

If you don't have a backup, then you are in trouble. Try www.mysql.org