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

[Drew Barnes]

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.
>
> Thanks for any pointers,
> John
>
> --- Ole Craig <ocraig at stillsecure.com> wrote:
>
>   
>> John -
>>     If your mysql database is located on /var and
>> /var filled up, you're
>> hosed. (If there's a database engine anywhere that
>> can deal gracefully
>> with an inability to write to its backing filestore
>> during normal
>> operations, it's definitely not MySQL.) 
>>
>>     Your best hope is probably to restore /var from
>> a backup made before
>> the partition choked.
>>
>>
>> 	Sorry, 
>> 		Ole
>>
>>     
>
>
>        
> ____________________________________________________________________________________
> Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. 
> http://answers.yahoo.com/dir/?link=list&sid=396545433
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>   

-- 
Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati