Leider bleibt dein Thread einiges an Information schuldig.
Sorry erst mal für die spärliche Information. Hier nun weitere Informationen.
Die Daten waren(vermutlich) aus der XAMPP Version 5.5.24.
Ich bin mittlerweile zu der XAMPP Version 1.8.2 gewechselt, bei dieser Version funktioniert der SQL Import wenigstens wieder.
Allerdings wenn ich den data Ordner wieder zurück schiebe, werden nicht alle Tabellen übernommen und bei denen die übernommen werden bekomme ich die Fehlermeldung
"#1146 - Table 'beispiel.k1bsn_session' doen't exist". in phpmyadmin, wenn ich die Struktur der Daten betrachten möchte.
Im Browser beim Aufruf der Seite bekomme ich dann zwangsläufig die Fehlermeldung: Error displaying the error page:
"Application Instantiation Error: Table 'beispiel.k1bsn_session' doesn't exist SQL=DELETE FROM `k1bsn_session` WHERE `time` < '1446213477'"In der Log-Datei steht jede Menge, aber auch nur Dinge die eigentlich klar sind bzw dass die Tabellen fehlerhafte Daten enthalten, oder?
Der Link zur Troubleshooting Seite hat mich leider auch nicht viel weiter gebracht, da mein Englisch recht begrenzt ist.
http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_ucm_base from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_ucm_content.frm'
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_ucm_history.frm'
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_update_sites from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_update_sites_extensions from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_updates from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_user_keys from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_user_notes.frm'
151030 16:11:19 [ERROR] Cannot find or open table agnesfrei/k1bsn_user_profiles from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_user_usergroup_map from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_usergroups from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_users.frm'
151030 16:11:19 [ERROR] Cannot find or open table beispiel/k1bsn_viewlevels from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_weblinks.frm'
151030 16:11:19 [ERROR] e:\xampp\mysql\bin\mysqld.exe: Incorrect information in file: '.\beispiel\k1bsn_wf_profiles.frm'
Aber Grundsätzlich rate ich immer davon ab den mysql data Ordner stumpf drüber zu kopieren.
Das habe ich jetzt gelernt.
Ich würde an Deiner Stelle die alte Version erst einmal wieder einspielen.
Habe ich gemacht, damit funktioniert es eben auch nicht mehr.
Danke für alle Tipps schon mal.