[rt-users] Couldnt open File 'sessions.MYI' in /opt/rt3/var/session_data

[John Schubert]

Ole,
Thank you so much.  I haven't used my skills with
computers in quite awhile and I never was really a
MySQL guru, so no, your idea isn't below my level.  I
understood every word Drew said, but had no idea how
to do it.

I will go through and practice with the tutorial
before I mess with the real one.  I'd read through the
MAN and Docs for MySQL, but somehow missed that
tutorial. 

I really do appreciate the help you've given.

Regards,
John

--- Ole Craig <ocraig at stillsecure.com> wrote:

>     Drew's right, if it's only the sessions table
> that's gone you're in
> luck, since that only tracks things related to who's
> currently logged
> in.
> 
>     And (since I well remember my first attempt to
> do something with
> mysql administration that was not scripted by an RPM
> installer... :-)
> before you do that, it'd probably be worthwhile to
> run through the
> "Creating and Using a Database" tutorial at
>
http://dev.mysql.com/doc/refman/5.1/en/database-use.html
> -- then you'll
> have a handle on what Drew means by "dropping the
> table and recreating
> it from the definitions". Apologies if you're
> already beyond this level.
> 
> 	Good luck,
> 		Ole
> 
> 
> 
> On Fri, 2007-07-13 at 11:59 -0400, Drew Barnes
> wrote:
> > Since it seems it is only the sessions table that
> is borked, you could
> > try dropping that table and recreating from the
> definitions in the RT
> > package you grab from BP's website.
> > 
> > 
> > John Schubert wrote:
> > > Are there any resources you've seen that were
> written
> > > well and described MySQL DB recovery?  I've been
> > > digging through the MySQL documentation and
> > > Yahoo/Googled for "How-To" articles, but most
> seem to
> > > assume a certain level of knowledge I don't
> possess.
> > >
> > > I feel dumb.  I can compile, run and maintain
> Apache,
> > > and admin Solaris, but I can't seem to get my
> hands
> > > around managing a simple DB.
> > > 
> -- 
> /Ole Craig
> Security Engineer
> Team lead, customer support
> 
> ocraig at stillsecure.com
> 303-381-3824 direct
> 303-381-3802 support
> 303-381-3880 fax
> 
> www.stillsecure.com
> 
> 



       
____________________________________________________________________________________
Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase.
http://farechase.yahoo.com/