Also den kompletten Ordner zu verschieben funktioniert schonmal nicht, da beim Versuch, Windows auf einen Wiederherstellungspunkt zurückzusetzen, alle .exe und .bat - Dateien aus dem XAMPP-Ordner und dessen Unterordnern entfernt wurden.
Ich habe jetzt versucht, nur den mysql-Ordner zu kopieren/überschreiben, aber da erkennt er nichtmehr die Tabellen.
Im error_log beschwert sich MySQL über fehlende .ibd Files. Ich finde aber nirgendwo welche.
2014-04-18 09:02:55 1308 [ERROR] InnoDB: Could not find a valid tablespace file for 'aqua@002dtours/at_2014_users'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2014-04-18 09:02:55 a7c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_users" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_commentmeta" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_comments" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_links" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_ngg_album" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_ngg_gallery" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_ngg_pictures" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_options" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_postmeta" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_posts" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_term_relationships" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_term_taxonomy" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_terms" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_usermeta" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-04-18 09:02:57 e4c InnoDB: cannot calculate statistics for table "aqua-tours"."at_2014_users" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
Hier die Dateien, die ich im Ordner unter mysql/data/name-der-datenbank/ habe: