>Description: ------------- This morning we were unable to access our databases from our applications. After a closed check in the mysql-server, I found out that all the databases had disappear. A "show databases" returned only ONE DB named "vi.recover" , Is the first time I see this DB in our server. If I tryed to access this DB, "use vi.recover" I got an error ERROR 1102: Incorrect database name 'vi.recover'. All the files from the different DB where still in the HD. After a shutdown of the mysql-server, check of the DB and starting the mysql-server again, all my DB where back and "vi.recover" disappear. - We use iasam tables. - Some of them are some GB big with some millions entries. - This is the first time I see this happend with the server and I am very worried, because these DB are a central part of our system and must be running all the time. If you need more info, just ask me about it. In advance, thank you for your help. >How-To-Repeat: --------------- No idea. No errors log anywhere. >Fix: ----- The only way to get all the databases back is to shutdown the mysql-server, run myisamchk in all the databases and start the mysql-server again. >Submitter-Id: -------------- Rafael Martinez >Originator: >Organization: >MySQL support: [none] >Synopsis: Databases disappear from the server but Mysql server does not crash. >Severity: <[ critical ]> >Priority: <[ high ]> >Category: mysql >Class: <[ sw-bug ]> >Release: mysql-3.23.38 (Source distribution) >Environment: ------------- System: FreeBSD name.domain 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Fri May 11 00:13:53 CEST 2001 /usr/src/sys/compile/MYKERNEL i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='cc' CFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads' CXX='c++' CXXFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1174570 Apr 21 11:05 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 May 10 03:58 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 561580 Apr 21 11:05 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/usr/local/mysql/var --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r' --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd --------------------------------------------------------------------- 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