How can I reset a 'ghost' table in MySQL?

Asked Feb 24 '14 at 23:05

Active Feb 24 '14 at 23:05

Viewed 101 times

My computer was recently wiped and restored, and one of the tables in my MySQL database has entered a ghost-like state: I cannot delete it, I get an error claiming the table doesn't exist, and I cannot create a new table with that name, I get an error claiming the table already exists. This table did not have any important information in it, so I think the easiest thing would be to delete it for good. Any way I can do this? I'm running the database locally, so I have access to everything.

Here are the exact errors:

When I try to drop the table:

#1051 - Unknown table 'sessions'

When I try to create a new table:

#1050 - Table '`database`.`sessions`' already exists

asked Feb 24 '14 at 23:05

Greg

1,225
3
16
35

2

[this question](http://stackoverflow.com/questions/10538908/schrodingers-mysql-table-exists-yet-it-does-not?rq=1) has some potentially helpful suggestions. – Mike Christensen Feb 24 '14 at 23:07
2

can you drop the entire schema from where that table is from? – CIRCLE Feb 24 '14 at 23:11
@MikeChristensen Unfortunately, the answers there don't seem to be helping me. I'll keep trying these. – Greg Feb 24 '14 at 23:26
@CIRCLE I'd rather not. There's a lot of other stuff that could be troublesome to recreate. I might have to try this as a last resort. – Greg Feb 24 '14 at 23:27
@Strawberry It is not a view. – Greg Feb 24 '14 at 23:27
Sounds like something exists on the filesystem that shouldn't.. – Mike Christensen Feb 24 '14 at 23:40
@MikeChristensen Yeah, but the question is where? – Greg Feb 24 '14 at 23:51
@CIRCLE I deleted the database and re-imported another copy, that worked. – Greg Feb 25 '14 at 00:54
So you tried `DROP VIEW sessions;` ? – Strawberry Feb 25 '14 at 11:35
@Strawberry Yeah, and was told that the view did not exist. – Greg Feb 25 '14 at 18:00

How can I reset a 'ghost' table in MySQL?

0 Answers0