Re: Can't see table information

[Jason St. Louis]

Hi.  Thanks for the response.
Here is all the relevent information you asked for:
[EMAIL PROTECTED] mysql]$ ./bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 130 to server version: 3.23.55
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use gb;
Database changed
mysql> show tables;
Empty set (0.01 sec)
mysql> show table status;
Empty set (0.00 sec)
mysql> show table status from gb;
Empty set (0.01 sec)
mysql> select count(*) from player;
+----------+
| count(*) |
+----------+
|       15 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from gb.player;
+----------+
| count(*) |
+----------+
|       15 |
+----------+
1 row in set (0.00 sec)
mysql> Bye
[EMAIL PROTECTED] mysql]$ ./bin/mysqlshow -u root -p gb
Enter password:
Database: gb
+--------+
| Tables |
+--------+
+--------+
[EMAIL PROTECTED] mysql]$ ./bin/mysqlshow --status -u root -p gb
Enter password:
Database: gb
+------+------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+---------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | 
Max_data_length | Index_length | Data_free | Auto_increment | 
Create_time | Update_time | Check_time | Create_options | Comment |
+------+------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+---------+
+------+------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+---------+

As you can see, it doesn't matter how I go about it, I always get the 
same result.  I issued the "select count(*) from player" statement to 
show that even though it doesn't show any tables, I can still perform an 
sql statement against a table that should be there.

I do not have a configuration file (I assume you are reffering to the 
my.cnf file?)  I guess this is something you have to manually create and 
I suppose I never did that.  I guess that means my mysql server is using 
all defaults.

I would just re-install mysql, except that I can't even do a mysqldump 
to get my data/table structure out of the database because of this 
problem.  guess I should have been taking backups, eh?

Is there any other relevant information I can provide that may help?
Here is the mysql user table entry for the user I am using to perform 
these statements:

mysql> select * from user where user = 'root' and host='localhost';
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host      | User | Password         | Select_priv | Insert_priv | 
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | 
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv 
| Index_priv | Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | -protected------ | Y           | Y           | Y 
        | Y           | Y           | Y         | Y           | Y 
       | Y            | Y         | Y          | Y               | Y 
       | Y          |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.00 sec)

Thanks.
Jason
Gleb Paharenko wrote:
Hello.

Sounds very strange. May be there is a bug, and it would be great if someone
corrects me, but I haven't found anything related in bugs database.
You said that you issued "show tables" statement on your database? Maybe 

it would be helpful to try not only "show tables from your_database", but
also:
 use your_database;
 show tables;
or
 show table status;
 show table status from your_db;

What output the command line utility mysqlshow produced?
  mysqlshow your_database
  mysqlshow --status your_database

When you were making selects did you use db_name.tbl_name syntax to refer to 

a table? Send us your config file (however I don't know if it would be helpful,
but this is a good practice).

"Jason St. Louis" <[EMAIL PROTECTED]> wrote:

Hi Folks,

I've been running a website on php/mysql database for about a year now.  
I typically enter data using the phpmyadmin package.  The other day I 
attempted to add some data but it appeared to phpmyadmin that there were 
no tables in my database.  I connected to mysql using the commandline 
client and issued a "show tables" statement on my database, which came 
back with an empty set.  However, if I run a select statement against 
tables I know should be there, I get results.  So the data is still 
there, I just can't see the tables.  Does anyone have any idea what 
might be causing this?  I am the only one who has access to the database 
so the priveleges for the user should not have changed.  I created an 
additional user with
"Grant all privileges on *.* to 'user'@'host' identified by 'password' 
with grant option;"
and attempted to view the tables with that user, with the same results.


Any ideas?


mysql version is: Ver 11.18 Distrib 3.23.55, for pc-linux (i686)


Thanks.
Jason



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]