[support] Newbie with a dead site

[erase]

Hi Laura

Thanks for the suggestion but could you be a little more explicit, how
would I do that? I'm new to mysql as well as Drupal?

Many Thanks
Phil

On 5/7/07, Laura Scott <laura at pingv.com> wrote:
> Phil, you could just empty the sessions table. The net effect is that
> everyone would have to log in again, that's all. You might try
> emptying your cache table, too, while you're in there.
>
> Laura
>
> On May 7, 2007, at 3:48 PM, erase wrote:
>
> > 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/ ]
> >>
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>