shell# myisamchk -v -c -m -B -r -d -S /usr/local/var/pcdocrx/temp.MYI
MyISAM file: /usr/local/var/pcdocrx/temp.MYI
Record format: Packed
Character set: latin1 (8)
File-version: 1
Creation time: 2001-12-03 10:31:16
Status: open,changed
Data records: 1987 Deleted blocks: 0
Datafile parts: 3488 Deleted data: 0
Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4
Datafile length: 201948 Keyfile length: 33792
Max datafile length: 4294967294 Max keyfile length: 4398046510079
Recordlength: 75
table description:
Key Start Len Index Type Rec/key Root
Blocksize
1 5 254 multip. varchar packed 0 5120
2048
1 4 float 0
Seems ok to me...
-----Original Message-----
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 11:19 AM
To: 'Gill, Vern'; [EMAIL PROTECTED]
Subject: RE: SHOW TABLES; show nothing
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
