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: <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 20000731 (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: lrwxrwxrwx 1 root root 13 Mar 20 09:15 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 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]