Rene Churchill writes:
>
> I'm having a problem with mysql forgetting the location
> of it's datadir. After the server has been running for
> some time, it looses track and starts throwing errors
> when I attempt to select a database. Killing mysqld
> and letting safe_mysqld restart it fixes the problem
> for a while, but having to do it 10 times a day is a
> bit much.
>
> I've recompiled the server with the datadir set via
> ./configure instead of the command line of safe_mysqld.
> That seems to have reduced but not eliminated the
> frequency of the problem. This could also be a side
> effect of less traffic on the weekends.
>
> mysqld - 3.23.29
> gcc - 2.95.2
> OS - MaxOS 10.0, Darwin 1.3.7
> Apache - 1.3.19
> PHP - 4.0.x?
>
> I'm currently waiting for it to start throwing these
> errors again before I can do a mysqladmin variables
> and extended-status. These will be submitted via
> support.mysql.com
>
> Has anybody else seen this kind of behavior? Any
> suggestions on how to debug it?
>
> Thanks,
> Rene
>
>
>
>
> --
> René Churchill [EMAIL PROTECTED]
> Vermont Web Wizard, LLC 802-244-5151
> Specializing in Web Programming 802-244-5512 (fax)
> http://www.vtwebwizard.com
No, but please if you can find when and why datadir is changed, that
would be nice.
Also send the output from mysqladmin var that shows that change has
occured. Also check if there is anything in the logs.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.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
