Running XAMPP 1.8.3 on Windows 7 64 bit Pro, all working okay until I added a database and a new user this morning.
Set up new database with one table in it and then tried to set up a new user. mySQL crashed and would not restart. Error log had something about tables it couldn't access:
I searched on-line for help and found that I could delete mysql\data\ibdata1 and could then restart mySQL, but I still couldn't create a new user.
I copied up all the mysql\data tables to another drive and tried some more recommendations, which included deleting some of the tables, but none worked, so I restored the table files.
I followed these instructions to mysql.ini:
Restoring MySQL InnoDB Files on Windows
I don't know when the tables were lost, but phpMyAdmin now reports that the tables do not exist -- but the table files are still in the mysql\data\ folder and they are unchanged from when they were working.
** I have a backup of the entire XAMPP install before all of this began, when things were working well. I compared the backup to what is currently in the data directory and the files are identical.
mysql > show databases
... the only databases that showed were information_schema and test.
Help. How do I get mySQL to recognize the tables? ... I can live without creating new users, but it would be nice if I could do that as well (this is a local test install and users aren't important to me).
below my reference so I can remember what I looked at: