Originally Posted by jojanmpaul
The internal MySQL meta-data is a single file or multiple files?. In Linux every thing is a file right, so we should be able to trace it, if it is a single file could be able to delete meta-data belongs to the deleted tables right?, am a small fry in Linux. Please don't mind my silly questions.
MySQL meta-data is spread across multiple "tables" which are stored in multiple files. You REALLY do not want to delete those files or you will wreck the mysql server, users and permissions, tables and indexes unrelated to your current problem - etc.
The problem exists because the meta-data is out of sync with the filesystem due to the files being deleted. Deleting more files will only make the problems worse and probably non-recoverable.
At this time the only things affected are related to the deleted tables, and the solution is to restore the tables AND bring the meta-data back into alignment with the actual table data storage files.
I can only repeat what I said earlier - there is no filesystem solution for this, you absolutely must let MySQL sort it out for you, and the way to do that is to tell MySQL to discard the incorrect tablespace, drop the tables (which will clear ALL the meta-data assoicated with them), then re-create the tables, which will also recreate valid meta-data for them.
May I ask why it seems necessary to do it without access to the mysql client? You must have had privileged access to delete the files? Just curious.