Ive seen plenty examples in books but are there any working MySQL examples someone can use immediately..Anything anywhere? Thank You, Martin ----- Original Message ----- From: "Marko Hrastovec" <[EMAIL PROTECTED]> To: "'gerald_clark'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 10:11 PM Subject: RE: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
> 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: <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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
