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

[Ole Craig]

    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