Hi, I am running mysql 3.23.53 on FreeBSD 4.4. I compiled mysql from source with the following configure command:
--prefix=/usr/local --localstatedir=/var/db/mysql Every now and then, the server seems to change its database directory to /var/tmp. When it happens, "show databases" gives me the content of the /var/tmp directory! I had this problem for more than a year now, and I upgraded every time a new version was available hoping it would fix it. I noticed that the higher to load on the mysql daemon, the more likely it is to happen... So there is probably a race condition or something. The manual says mysql is less reliable on FreeBSD because of the poor multi-threading implementation. I didn't expect I'd have to restard it every day (!!) Any help would be very appreciated. Thank you, Cedric --------------------------------------------------------------------- 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