On Wed, Jul 25, 2001 at 03:19:03PM +0200, Sebastiaan Smit wrote:
> Hello,
>
> I'm having a problem with MySQL when it runs for a couple of
> days. At some time mysqld 'forgets' where it's databases are and
> searches for them in the mysql temp dir. (In my case /var/tmp). In
> the tmp dir there is always the recover directory for vi
> (vi.recover) so mysqld thinks that it's the only database.
>
> Funny enough mysql remembers what the grant rights are for all the
> users. I've searched the mailing lists/newsgroups for this
> problem. This problem was reported before by D. Jordan on 2000/10/05
> and a month before that. Sadly nobody replied to it. :(
>
> Does somebody know what's going on?
>
> Specs: FreeBSD 4.3 RELEASE, Mysql 3.23.39, PHP 4.0.5, Apache 1.3.20 all
> built from ports.
You have gremlins in your machine.
Seriously, that's rather odd. Can you pinpoint when exactly it
happens? Can you match up the problem with anything in your crontab,
system logs, or MySQL logs?
I have to think that some external change is causing this. It's very
odd for MySQL to decide to change data directories on the fly like
that. In face, you're not supposed to be able to change it without
restarting the server.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 43 days, processed 339,373,720 queries (89/sec. avg)
---------------------------------------------------------------------
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
