Hi,
I hope to be helpful for further investigation of the problem.
On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
> >Description:
> I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> all 'show' commands doesn't works. They display empty tables.
In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0
sources from www.mysql.com compliled and work pretty well.
> >How-To-Repeat:
> $ mysql
> mysql> show databases;
> +----------+
> | Database |
> +----------+
> | |
> | |
> | |
> | |
> | |
> | |
> | |
> | |
> +----------+
> 8 rows in set (0.00 sec)
>
> mysql> use UNEXISTANT;
> ERROR 1049: Unknown database 'UNEXISTANT'
>
> mysql> use mysql;
> Database changed
>
> mysql> show tables;
> Empty set (0.00 sec)
>
>
> As we can see, there are AVAILABLE databases, but 'show databases'
> doesn't displays anything. We can make 'use' with correct names,
> can't with unexistant, but the tables in database can't be reached.
>
>
> BTW, I have found the dependence of number in line ('8 rows in set)
> above - it corresponds to number of entries in /var/lib/mysql/
> directory:
>
> $ ls -a /var/lib/mysql/
> . Phantom.log Phantom.tsk.ru.pid mysql.sock
> .. Phantom.tsk.ru.err mysql test
On my RH 6.2 there is another dependancy. show databases returns number of
entries in the directory without . and ..
Moreover, show tables returns very nice list of tables' names. All names are
truncated in the first 4 characters (tables_priv -> es_priv). Perhaps it's
interesting to know that my data folder is /data.
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> gcc version 2.96 20000731 (Red Hat Linux 7.0)
> Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6
> -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was
not installed.
On RH7.0 I compiled with gcc and libstdc++ was installed.
It looks like we have problems with either egcs or libstdc and company.
Hope it helps MySQL developers.
Best regards,
Lumberer.
---------------------------------------------------------------------
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
