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

2007-07-18 Thread John Schubert
LL > | | > | LastUpdated | timestamp | YES | | > CURRENT_TIMESTAMP | | > +-+-+--+-+---+---+ > 3 rows in set (0.00 sec) > > > > James Moseley &

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

2007-07-18 Thread John Schubert
I went through the MySQL tutorials and created test tables to delete, within test databases and got that down. I also went ahead and practiced importing and populating fields within a table, from a flat file. I've gone through all the the RT documentation, researched the archives, and even went t

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

2007-07-13 Thread John Schubert
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,

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

2007-07-13 Thread John Schubert
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 maintai

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

2007-07-11 Thread John Schubert
Thanks Ole, I checked and with the standard install my database is indeed in /var. I'm playing with myisamchk to see if there's a way to restore. I asked the IT department to back this server up for years, but they've ignored me. This is the only machine I have permissions, otherwise I'd have

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

2007-07-11 Thread John Schubert
First post didn't get a single reply, so please let me know if I'm not posting correctly. I've read the FAQs and posted on this list before. The system is a 3 year old RT (RT 3.0.4 I believe) that has been running without problems. The /var partition filled up at some point in time and this erro

[rt-users] RT Couldn't Write to Session Dir - ?var at 100%

2007-07-03 Thread John Schubert
First, I googled this error and dug through archives before posting. SysInfo System: Intel PC running RedHat Linux Release 7.3 (Valhalla), kernel 2.4.18-3 Perl 5.6.1 ModPerl 1.29 Apache 1.3.29 (error log file is c