RE: SHOW TABLES; show nothing

[Quentin Bennett <quentin.bennett@xxxxxxxxxxxxxx>]

Hi,

Try myisamchk'ing you mysql tables.

Regards

Quentin

-----Original Message-----
From: Gill, Vern [mailto:vgill@xxxxxxxxxxxxxxxx]
Sent: Monday, 3 December 2001 5:40 p.m.
To: mysql@xxxxxxxxxxxxxxx
Subject: SHOW TABLES; show nothing


mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax
TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic
VARCHAR(7));
Query OK, 0 rows affected (0.09 sec)

mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> DESCRIBE faxblast
    -> ;
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| Field       | Type                 | Null | Key | Default | Extra |
Privileges                      |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| company     | varchar(100)         | YES  |     | NULL    |       |
select,insert,update,references |
| phone       | varchar(12)          | YES  |     | NULL    |       |
select,insert,update,references |
| fax         | tinyint(10) unsigned | YES  |     | NULL    |       |
select,insert,update,references |
| state       | char(2)              | YES  |     | NULL    |       |
select,insert,update,references |
| description | varchar(80)          | YES  |     | NULL    |       |
select,insert,update,references |
| sic         | varchar(7)           | YES  |     | NULL    |       |
select,insert,update,references |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
6 rows in set (0.01 sec)

mysql> use mysql
Database changed
mysql> use pcdocrx
Database changed
mysql> DESCRIBE faxblast;
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| Field       | Type                 | Null | Key | Default | Extra |
Privileges                      |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| company     | varchar(100)         | YES  |     | NULL    |       |
select,insert,update,references |
| phone       | varchar(12)          | YES  |     | NULL    |       |
select,insert,update,references |
| fax         | tinyint(10) unsigned | YES  |     | NULL    |       |
select,insert,update,references |
| state       | char(2)              | YES  |     | NULL    |       |
select,insert,update,references |
| description | varchar(80)          | YES  |     | NULL    |       |
select,insert,update,references |
| sic         | varchar(7)           | YES  |     | NULL    |       |
select,insert,update,references |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
6 rows in set (0.00 sec)

mysql> SHOW TABLES;
Empty set (0.00 sec)

Someone please explain to my why this is happening?

In fact, could someone explain this too?;
# mysql -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 66 to server version: 3.23.28-gamma

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
|          |
|          |
|          |
|          |
|          |
|          |
|          |
+----------+
7 rows in set (0.00 sec)

mysql> SHOW TABLES;
ERROR 1046: No Database Selected
mysql> use mysql
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> quit
Bye
[root@localhost /tmp]# ls /usr/local/var/
total 20k
4.0k drwx------    2 root     root         4.0k Dec  2 20:20
PC_Doctor_RX.orig/
4.0k drwx------    2 root     root         4.0k Dec  2 11:02 mysql/
4.0k -rw-r--r--    1 root     root            5 Nov 29 16:26 mysqld.pid
4.0k drwx------    2 root     root         4.0k Dec  2 20:29 pcdocrx/
4.0k drwx------    2 root     root         4.0k Nov 30 12:01 ulog/

Vern H. Gill
State Director
Director of Marketing
Conejo Valley Jaycees
http://www.conejovalleyjaycees.org

---------------------------------------------------------------------
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 <mysql-thread92879@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-quentin.bennett=infinity.co.nz@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

---------------------------------------------------------------------
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 <mysql-thread92922@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php