Greetings, I've newly installed mysql 4.1 (alpha) and then back to 4.0.18 and having some trouble.
After compiled and installed I start it with mysqld_safe. I then am able to access my 2 databases. I have a homebrewed database for a BBS and then a stock phpBB database. If I connect to my BBS software first, and then access my PHP stuff I see this: SQL Error : 1105 File './phpbb/phpbb_user_group.MYD' not found (Errcode: 9) (It is there!) So, then I shutdown and restart mysql, and connect to my PHPBB database first. Then I connect to my BBS software and I see this: error! mysql_query errno: 1017 error: Can't find file: './bbs/room102.frm' (errno: 9) (Again, custom brewed errors as well) If I leave one of these running it's fine. But I cannot seem to run both. Once that error occurs, the other also becomes unstable. I'm totally stumped. This was previously running on a slackware Linux system, with the same version of MySQL. Can anyone offer any suggestions? I compiled mysql like so: CFLAGS=-O3 CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/opt/mysql/ --enable-assembler --with-mysqld-ldflags=-all-static -=-= Reading specs from /usr/local/lib/gcc-lib/sparc64-unknown-openbsd3.4/3.3.3/specs Configured with: /mnt/gcc-3.3.3/configure Thread model: single gcc version 3.3.3 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]