today I faced a strange situation...suddenly when trying to access a table through PHPMyAdmin...I got a message saying'tables does not exist'...nonetheless the table and its columns were listed in the directory tree.
After a search I made my case looked like this(with the same symptoms)
http://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp
This the table for which I was getting the above message..
CREATE TABLE `business_users` (
`crID` mediumint(11) unsigned NOT NULL,
`address` varchar(90) DEFAULT NULL,
`url` varchar(90) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`municipality` varchar(100) DEFAULT NULL,
`bus_user_type` enum('1','2','3','4','5') CHARACTER SET latin1 DEFAULT NULL,
`pack_selected` smallint(6) unsigned NOT NULL,
`same_d_appt` tinyint(4) DEFAULT NULL,
`f_words` tinytext,
`apps_timeslot` tinyint(3) unsigned DEFAULT NULL,
`prices_visibility` tinyint(1) unsigned DEFAULT NULL,
PRIMARY KEY (`crID`),
KEY `fk_business_users_buz_usertype1_idx` (`bus_user_type`),
CONSTRAINT `busers_packages` FOREIGN KEY (`pack_selected`) REFERENCES `packages` (`package_ID`),
CONSTRAINT `fk_business_users_users1` FOREIGN KEY (`crID`) REFERENCES `users` (`user_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
The topic in stackoverflow mentions something about tablespace full error...
If that is indeed the case how am I going to be sure this was the problem(I have fixed it now by dropping the entire dbase and importing a backup).
I am trying to find what caused this sudden message I described in the beginning...do you think there is something "wrong" with the structure of the table above.