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

[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 just
backed it up myself.  I didn't backup to itself just
cause the harddrive isn't terribly large.

I'll keep digging through MySQL and see if I can
overcome the odds and get the DB back up.  If I'm
successful, I'll post what I did.

Thanks again,
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
> 


       
____________________________________________________________________________________
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. 
http://mobile.yahoo.com/go?refer=1GNXIC