[drupal-support] Corrupted Sessions Table

[Ken Dow]

Hi,

I had an 4.4.2 site outage this morning with the following error:

Fatal error: Can't open file: 'sessions.MYD'. (errno: 145) query: 
SELECT u.*, s.*, r.name AS role FROM users u INNER JOIN sessions s ON 
u.uid = s.uid LEFT JOIN role r ON u.rid = r.rid WHERE s.sid = 
'e9cc93bab76197fbf51609636250a9f8' AND u.status < 3 LIMIT 0, 1 in 
/home/httpd/vhosts/mydomain.ca/httpdocs/includes/database.mysql.inc on 
line 97

The site was moved to a different directory and database location (same 
Apache/PHP/MySQL host) last week and was running fine over the weekend.

When I checked with phpMyAdmin, it was unable to open the sessions 
table, so I dropped and recreated it and then everything was fine. My 
questions:

1) Could moving a Drupal installation, including the database with 
sessions table and other data, cause this? Should some data not be 
moved - only the table structure?

2) Should I be concerned about other possible errors in the database?

Thanks in advance.

--
Ken

Chase two rabbits, catch none.
- Japanese proverb