dougnyc Posted December 5, 2002 Posted December 5, 2002 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 Posted December 5, 2002 Author Posted December 5, 2002 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 Posted December 5, 2002 Posted December 5, 2002 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.