I had this problem.
For some reason MySQL has decided to look at your tmp directory (which
contains vi.recover) instead of your data directory. Compiling
with -DHAVE_BROKEN_REALPATH fixed it for me, on FreeBSD 4.6, linuxthreads
and dual CPU.
--Mike
----- Original Message -----
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: "Simas Cepaitis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 25, 2002 9:04 AM
Subject: Re: MySQL loses databases
> Pada Thu, 25 Jul 2002 09:28:45 +0200
> Simas Cepaitis <[EMAIL PROTECTED]> menulis :
>
> > Hello,
> >
> > Earlier i posted my message here, but haven't got any real solution.
> > So now I'll try to post with some more details. I have a FreeBSD 4.6
> > box, dual cpu, runing MySQL. It runs with linuxthreads enabled
> > and it is under heavy load all the time. Few weeks ago it started
> > to work a little strange. MySQL runs ok for some period of time,
> > and then it disallows connections from users, saying 'access not
> > allowed for user@localhost'. Root can connect without problems.
> > The strange thing is, that MySQL somehow 'loses' it's databases.
> > When I connect as root, 'show databases' output gives me one
> > database... vi.recover. So I suppose, that MySQL drops it's path
> > somewhere, but I'm not sure why. The only workaround I have for
> > now is run database check every minute, and restart MySQL if
> > needed. After restart everything looks OK for some time ( one - two
> > days)... This problem was with 3.23.49, and now I saw this with
> > 3.23.51 too. Any ideas what could be wrong?
>
> vi.recover .... isn't it from "VI" application ???
>
> Maybe someone is trying to do something inside your mysql data directory
... and somehow he damage your DB
> Try to investigate it from FILE side ;-)
>
> >From my experiences, mysql never lost the databases ... because it's
based on directory structure on your filesystem OS. eventhough it's mysql
bug and your db corrupt, the directory should be still exist and you can see
from show databases.
>
> --
> printk("??? No FDIV bug? Lucky you...\n");
> 2.2.16 /usr/src/linux/include/asm-i386/bugs.h
>
> MySQL 3.23.51 : up 34 days, Queries : 354.952 per second (avg).
>
> --
> Dicky Wahyu Purnomo - System Administrator
> PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
> Phone : +62 21 79199577 - Web : http://1rstwap.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
