I am using Ubuntu Linux version 12.04 with Linux kernel 3.2.0-61-generic-pae.
The XAMPP version is 1.8.3. The MySQL setup uses ISAM tables.
It seems possible for the MySQL database to get into a state where a table created by the user appears not to exist. The symptoms are:
[list=]
[*]Attempts to access the table provoke the MySQL error message #1146 "Table ... doesn't exist".
[*]Attempts to create the table using CREATE TABLE IF NOT EXISTS provoke the same error message.
[*]If the database which contains the table is the current database, the table's name is included in the list of tables produced by the SHOW TABLES command.
[*]There is a .frm file for the table (this should be the case because ISAM tables are being used), but no .MYD or .MYI files for it (not needed if the table is empty).
[*]The table does NOT appear in the MySQL information_schema database's table TABLES.
[/list]
I do not have enough information to say whether this is a basic bug in MySQL or in the way in which MySQL databases are handled in XAMPP when ISAM tables are used. However, I have found other reports in other fora of similar behaviour also in earlier versions of XAMPP. The faulty state of the database seems to appear quite at random -- or perhaps I should say that I haven't been able to find any clues to what causes it.
For the user who experiences this problem there is a fix: Delete the .frm file, restart the MySQL server and create the table. However, this requires root privileges, so this "solution" is not viable for all users. A permanent solution would definitely be preferred!
[EDIT by Altrea: moved to the english section of this board]