That was my first thought too. Shouldn't then MySQL also report nonexisting
databases? When I run client "mysql database_name" it runs only on existing
databases. When I write wrong database name it won't run, so it look in the
right directory. If the database directory was wrong it shouldn't work on
other
four computers which have all RedHat Linux installed.
Regards
Marko
> -Original Message-
> From: gerald_clark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 4:26 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Upgrading from 3.23.5x to 4.0.12 version 4 show
> no tables in any database
>
>
> Add your database directory to your my.cnf file.
> They were possibly compiled with diferent default
> database locations.
>
> [EMAIL PROTECTED] wrote:
>
> >>Description:
> >>
> >>
> > I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat
> >operating system. On 3 machines I only upgraded the RPMs and
> >everything worked. On only Linux Redhat 7.3 server
> RPM upgrade
> >also worked fine. The problem is that mysql server report no
> >tables in any database. When I run MySQL client
> "show tables;"
> >return empty dataset in databases. 3.23.5x work fine.
> >
> > I am reporting this from the server where upgrade was
> successful.
> > The server where error occured is almost identical it only is
> >Redhat 7.3 instead of 7.2.
> >
> >
> >>How-To-Repeat:
> >>
> >>
> > I have downgraded to 3.23.56 where tables are seen. Every time I
> >upgrade I get the same error.
> >
> >
> >>Fix:
> >>
> >>
> > No idea.
> >
> >
> >
> >>Submitter-Id:
> >>Originator:
> >>Organization:
> >>
> >>
> >
> >
> >
> >>MySQL support: none
> >>Synopsis: Upgrade problem
> >>Severity: serious
> >>Priority: medium
> >>Category: mysql
> >>Class: sw-bug
> >>Release:mysql-4.0.12 (Official MySQL RPM)
> >>Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for
> pc-linux on i686
> >>
> >>
> >Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> >This software comes with ABSOLUTELY NO WARRANTY. This is
> free software,
> >and you are welcome to modify and redistribute it under the
> GPL license
> >
> >Server version 4.0.12
> >Protocol version 10
> >Connection Localhost via UNIX socket
> >UNIX socket /var/lib/mysql/mysql.sock
> >Uptime: 3 days 15 hours 11 min 33 sec
> >
> >Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151
> Flush tables: 1 Open tables: 46 Queries per second avg: 0.010
> >
> >
> >>C compiler:2.95.3
> >>C++ compiler: 2.95.3
> >>Environment:
> >>
> >>
> >
> >System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001
> i686 unknown
> >Architecture: i686
> >
> >Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake
> /usr/bin/gcc /usr/bin/cc
> >GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> >gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-112.7.2)
> >Compilation info: CC='gcc' CFLAGS='-O6
> -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6
> -fno-omit-frame-pointer -felide-constructors
> -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
> >LIBC:
> >lrwxrwxrwx1 root root 13 Mar 20 09:15
> /lib/libc.so.6 -> libc-2.2.4.so
> >-rwxr-xr-x1 root root 1285884 Mar 6 16:03
> /lib/libc-2.2.4.so
> >-rw-r--r--1 root root 27338566 Mar 6 15:05
> /usr/lib/libc.a
> >-rw-r--r--1 root root 178 Mar 6 15:05
> /usr/lib/libc.so
> >Configure command: ./configure '--disable-shared'
> '--with-mysqld-ldflags=-all-static'
> '--with-client-ldflags=-all-static' '--without-berkeley-db'
> '--with-innodb' '--without-vio' '--without-openssl'
> '--enable-assembler' '--enable-local-infile'
> '--with-mysqld-user=mysql'
> '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
> '--prefix=/' '--with-extra-charsets=complex'
> '--exec-prefix=/usr' '--libexecdir=/usr/sbin'
> '--sysconfdir=/etc' '--datadir=/usr/share'
> '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
> '--includedir=/usr/include' '--mandir=/usr/share/man'
> '--with-embedded-server' '--enable-thread-safe-client'
> '--with-comment=Official MySQL RPM' 'CFLAGS=-O6
> -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6
> -fno-omit-frame-pointer -felide-constructors
> -fno-exceptions -fno-rtti -mpentium'
> >
> >
> >
> >
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]