Hi!
>>>>> "werner" == werner <ISO-8859-1> writes:
werner> Is it an option to drop the table and recreate and repopulate it?
werner> I would give it a try and think that your problem will be gone.
werner> You can easily do that with mysqldump. Ask again if you need more
werner> help.
werner> Alex Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26:
>> I've made some progress figuring out my case issue. It seems that somehow
>> I'm ending up with shadow tables. I discovered this after I ran an ALTER
>> command. My db has 4 tables:
mysql> show tables\g
>> +---------------------+
>> | Tables_in_hbperfrev |
>> +---------------------+
>> | employee |
>> | perfassessment |
>> | perfreview |
>> | workgroup |
>> +---------------------+
>> 4 rows in set (0.01 sec)
>> When I look at the perfassessment table, I see the two rows that I added via
>> alter, q10 and q11:
<cut>
mysql> describe PerfAssessment\g
>> +------------+---------+------+-----+---------+----------------+
>> | Field | Type | Null | Key | Default | Extra |
>> +------------+---------+------+-----+---------+----------------+
>> | ID | int(11) | | PRI | NULL | auto_increment |
<cut>
>> So clearly I have duplicate tables, and this explains all the case
>> sensitivity problems I was having earlier. But why doesn't the second one
>> show up when I do "show tables"? And how do I get rid of the second one?
I have never seen this problem before. The only explanations I have
for the above are:
- Somehow MySQL doesn't think you have the rights to look at the
PerfAssessment table with show tables.
What result do you get if you login as the MySQL root user ?
- You have just created a temporary table name PerfAssessment. In this
case the problem should disappear when you reconnect to MySQL.
What files do you have in the database directory ?
>> Any help is much appreciated, as I've been banging my head against the wall
>> for days. Again, this is 3.23.39, compiled from source, running on OS X
>> Server (details below).
>> Another question: I'm trying to remove some unused databases, but this
>> command:
>> ./mysqladmin -u root -p drop ac
>> (where 'ac' is the database name) doesn't seem to actually remove them from
>> the mysql database. Is there another command that completely removes
>> databases?
Yes, the above command should remove all database files in the 'ac' database,
for which the MySQL server has delete privilege.
Could you check verify there isn't some privilege problem with the files
in the ac database ?
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com
---------------------------------------------------------------------
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
