[support] Newbie with a dead site

[erase]

Thanks Dave

That did look hopefull reporting:

drupal.users
warning  : 3 clients are using or haven't closed the table properly
status   : OK
drupal.users_roles                                 OK

And now runs without error, but still reports the following on the site:

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

Thanks
Phil

On 5/7/07, Metzler, David <metzlerd at evergreen.edu> wrote:
> 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/ ]
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>