[support] Newbie with a dead site

[erase]

Thanks David & Laura for pointing me in the right direction I was then told:

mysql> delete from sessions;
ERROR 145 (HY000): Table '.\drupal\sessions' is marked as crashed and should be
repaired

Which after Googling around led me to:

C:\xampp\mysql\bin>mysqlcheck --repair drupal sessions -u root -p
Enter password: ********
drupal.sessions                                    OK

Which restored the site in a slightly broken state, if I can't fix
that I'll start another thread.

Many Thanks to you both
Phil

On 5/7/07, Metzler, David <metzlerd at evergreen.edu> wrote:
> At the mysql prompt.
>
> Mysql> delete from session;
>
> Mysql> delete fom cache;
>
> You might to another mysqlcheck after that just to be safe.
>
>
> -----Original Message-----
> From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
> Behalf Of erase
> Sent: Monday, May 07, 2007 3:07 PM
> To: support at drupal.org
> Subject: Re: [support] Newbie with a dead site
>
> 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/ ]
> >
> --
> [ Drupal support list | http://lists.drupal.org/ ]
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>