Okay: FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel PIII 1Ghz with 1G of RAM. All from source.
Compiled okay and came through super-smack and crash-me tests okay. But a few hours later, for no reason, MySQL decided to look at /var/tmp instead of /usr/local/mysql/var for the datadir. There is nothing in the logs to suggest why this happened. AFAIK, you have to restart mysqld to change the data dir, but the daemon was not restarted at any point. SHOW VARIABLES revealed that the datadir was still set to /usr/local/mysql/var, but SHOW DATABASES listed the contents of /var/tmp (in my case vi.recover). When I shutdown and restarted the system, it reverted to normal behaviour. Anyone have any idea what is going on? --Mike --------------------------------------------------------------------- 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
