Table exists, but doesn't, but does...

[Viflux]

Got a weird error here, not sure how to explain it.

I started getting errors in my gallery software.

Upon investigation, it's a MySQL error. It tells me that one of the necessary tables doesn't exist.

If I do a 'show tables;', it lists the table in question. If I do a 'describe table_name;' it tells me it doesn't exist. If I try to recreate it, it tells me it already exists.

Thoughts?

[r937]

CHECK TABLE tbl_name
REPAIR TABLE tbl_name

[Viflux]

Table 'tbl_name' doesn't exist.
Table 'tbl_name' doesn't exist.


I've decided to abandon this hassleware and write my own quick gallery thing.

Off Topic:


Never volunteer to maintain a website for your friends wedding pictures.

[longneck]

this behavior means one of two things:
1) if myisam tables, then the .frm file exists, but none of the other files do. the .frm file describes the table, the .myd file is the actual data and the .myi file is the index.
2) if innodb tables, then the server was either started or reconfigured without innodb, or the inno files have been moved or deleted. inno tables still have .frm files (and .myd or .myi depending on the mysql version) but the data is actually stored in the root of the data directory (ib*.* and innodb*.*).

[Thermit]

My problem is different, but the title of thread is perfect to describe my problem as well.

I've got some php code which is supposed to create a mySQL table if a "SELECT * FROM table" fails. When executed the first time, the code attempts to create the table and insert some data. On subsequent runs, it no longer attempts to create the table, implying it exists now (although it appears the data was not inserted). The strange part is that I can't actually see these CREATE'd tables when I use phpMyAdmin or mysqldump. If I force the code thru the CREATE section now, I get a duplicate table error, which confirms that the php is seeing something that I can't. The some DB interface is used for all operations.

Where are these ghost tables?

[longneck]

your problem is different. the user that your application uses created the table but did not give other users rights to that table. please don't hijack threads.

[Thermit]

Made a judgement call to recycle thread in this case.

Thanks for reply.