I have this strange issue. I have MySql workbench, which I use to write queries for MySQL database (xampp 3.2.1). Everything works fine, but recently I found myself having to profile the queries my app sends, so in the config file (
my.ini) I added this this line:
general_log = 1
After adding this line, my server starts, I can connect to it via workbench, but when I try to get the data from my database
SELECT * FROM applicantsDB.Applicants;
Error Code: 1146. Table 'applicantsDB.Applicants' doesn't exist
While the same query succeeds if the logging is off. I can still get data from my other databases. What might be causing this?
EDIT now it doesn't even work when logging is off (other dbs are fine). Tried creating a new db and importing the schema from
applicantsDB. Worked fine until I decided to restart the server. If I do the same without logging on, everything is fine (across restarts too) but when I enable logging, everything breaks.
sample error log:
2014-04-17 10:20:26 1878 InnoDB: Error: table 'applicantsdb/applicants' InnoDB: in InnoDB data dictionary has tablespace id 50, InnoDB: but the tablespace with that id has name applicantsDB/applicants. InnoDB: Have you deleted or moved .ibd files? InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. 2014-04-17 10:20:26 1878 InnoDB: Error: table 'applicantsdb/files' InnoDB: in InnoDB data dictionary has tablespace id 52, InnoDB: but the tablespace with that id has name applicantsDB/files. InnoDB: Have you deleted or moved .ibd files? InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
when I create the database with the name in lower case everything works fine. Still, this does not explain why enabling logging can break a database