Hi, Try myisamchk'ing you mysql tables.
Regards Quentin -----Original Message----- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 December 2001 5:40 p.m. To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php