[support] Newbie with a dead site

[Metzler, David]

You need to do a repair using the mysqladmin tools.  Something like: 

mysqlcheck -u root -p --auto-repair drupaldbname

Dave.  

-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of erase
Sent: Monday, May 07, 2007 2:30 PM
To: support at drupal.org
Subject: [support] Newbie with a dead site

Perhaps I should start by saying that I'm obviuosly very daft for not
having backed up the last few days work! Where I now am after power loss
is with a site reporting:

Warning: Table '.\drupal\sessions' is marked as crashed and should be
repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON
u.uid = s.uid WHERE s.sid = '207a004ebaa486e50fc0560a9dc892a8' in
C:\xampp\htdocs\includes\database.mysql.inc on line 172

But when I try running the command in mysql it just reports:

mysql> select drupal
    -> SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid =
s.uid WHERE  s.sid = '207a004ebaa486e50fc0560a9dc892a8';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'SELEC T u.*, s.* FROM users u INNER JOIN sessions s
ON u.uid = s.uid WHERE s.sid ' at line 2
mysql>

Any ideas where I go from here?

Thanks
Phil
--
[ Drupal support list | http://lists.drupal.org/ ]