drop table

Anon

aight, another question:

i messed up my table somehow, so i wanted to drop it. so i type in mysql the command

mysql> drop table tablename;

but it just sits there and HANGS

does anybody know what causes this and how i can drop this table?

thanks in advance,
case

edraynham

Are you sure that your user has permissions to DROP, onlined in Database 'mysql' Table 'user'?

Anon

yes, i am root.

Ed wrote:

Are you sure that your user has permissions to DROP, onlined in Database 'mysql' Table 'user'?

brandonschnell

if you're lazy like i am, stop mysqld, delete the table files from under the database folder (mine installs into /var/lib/mysql/db_name), then restart mysqld

[deleted]

that means nothing, the mysql user you are loggin in as needs permissions.
You can even lockout root if you want....

But that's not the problem I think, because if you did not have access, you would get an 'access denied" message.

Is there any harddisk activity while it "hangs"?

[deleted]

That's not lazy, it's bad bad bad naughty bad go stand in a corner and don't come out untill dinnertime then go to bed without dinner bad naughty bad.
🙂

brandonschnell

supposedly mysqld should have access to the file as it created it and mysqld would return an error if the user didn't have permissions from mysqld. if its hanging up something else besides permissions is probably causing it.

me thinks you might have hard drive problems ( call me cheap but I've run mysql for months on a hard drive that was failing and corrupting files left and right) run "repair database" from mysql client and fsck from the command prompt (safe way is to restart and force fsck to run on reboot, "shutdown -rF now")

like i was saying in an earlier post, if you stop mysqld and try to remove just the files that make up the tables (table.MYD, table.MYI,table,frm) you'll see right away what the problem is. its not the best way, but mysqld seems to loads tables/databases when its started so after restarting mysqld it'll load normally without the bad tables. i've used this method to repair databases that were toast and for new installations.