Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Help! My database really is corrupt.


Recommended Posts

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'



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


Now when I do that I get this:





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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...