brave_snoopy
24.04.08, 15:22
Hallo Leute,
mir ist irgendwie meine MySQL Datenbank zerstört. Ich habe kein Backup, da dies noch ein Versuchsserver ist.
habe mich dann an der console mit mysql -u benutzername -p und nem kennwort am sql server angemeldet.
mich per use web101 mit der db verbunden, dann bekam ich unten stehende ausgabe.
Habe dann versucht z.b. mit REPAIR TABLE fe_users, aber hier wurde mir dann gesagt, das die verbindung zum mysql server getrennt wurde.
ein myisamchk *.MYI bzw. dann mit dem -r Parameter hat nichts gebracht.
Hat jemand eine idee, wie ich das nun wieder gerade biege? Vor allem scheint auch die User Tabelle beschädigt zu sein, denn wenn ich über phpmyadmin auf die db zugriefen will, erhalte ich ebenfallsdie meldung, mit dem gone away.
No connection. Trying to reconnect...
Connection id: 4
Current database: web101
Didn't find any fields in table 'cache_pagesection'
Didn't find any fields in table 'cache_typo3temp_log'
Didn't find any fields in table 'fe_groups'
Didn't find any fields in table 'fe_session_data'
Didn't find any fields in table 'fe_sessions'
Didn't find any fields in table 'fe_users'
Didn't find any fields in table 'pages'
Didn't find any fields in table 'pages_language_overlay'
Didn't find any fields in table 'static_template'
Didn't find any fields in table 'static_tsconfig_help'
Didn't find any fields in table 'sys_be_shortcuts'
Didn't find any fields in table 'sys_domain'
Didn't find any fields in table 'sys_filemounts'
Didn't find any fields in table 'sys_history'
Didn't find any fields in table 'sys_language'
Didn't find any fields in table 'sys_lockedrecords'
Didn't find any fields in table 'sys_log'
Didn't find any fields in table 'sys_note'
Didn't find any fields in table 'sys_preview'
Didn't find any fields in table 'sys_refindex'
Didn't find any fields in table 'sys_refindex_rel'
Didn't find any fields in table 'sys_refindex_res'
Didn't find any fields in table 'sys_refindex_words'
Didn't find any fields in table 'sys_template'
Didn't find any fields in table 'sys_workspace'
Didn't find any fields in table 'tt_content'
Didn't find any fields in table 'tx_impexp_presets'
Didn't find any fields in table 'tx_rtehtmlarea_acronym'
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
ERROR:
Can't connect to the server
mysql>
mir ist irgendwie meine MySQL Datenbank zerstört. Ich habe kein Backup, da dies noch ein Versuchsserver ist.
habe mich dann an der console mit mysql -u benutzername -p und nem kennwort am sql server angemeldet.
mich per use web101 mit der db verbunden, dann bekam ich unten stehende ausgabe.
Habe dann versucht z.b. mit REPAIR TABLE fe_users, aber hier wurde mir dann gesagt, das die verbindung zum mysql server getrennt wurde.
ein myisamchk *.MYI bzw. dann mit dem -r Parameter hat nichts gebracht.
Hat jemand eine idee, wie ich das nun wieder gerade biege? Vor allem scheint auch die User Tabelle beschädigt zu sein, denn wenn ich über phpmyadmin auf die db zugriefen will, erhalte ich ebenfallsdie meldung, mit dem gone away.
No connection. Trying to reconnect...
Connection id: 4
Current database: web101
Didn't find any fields in table 'cache_pagesection'
Didn't find any fields in table 'cache_typo3temp_log'
Didn't find any fields in table 'fe_groups'
Didn't find any fields in table 'fe_session_data'
Didn't find any fields in table 'fe_sessions'
Didn't find any fields in table 'fe_users'
Didn't find any fields in table 'pages'
Didn't find any fields in table 'pages_language_overlay'
Didn't find any fields in table 'static_template'
Didn't find any fields in table 'static_tsconfig_help'
Didn't find any fields in table 'sys_be_shortcuts'
Didn't find any fields in table 'sys_domain'
Didn't find any fields in table 'sys_filemounts'
Didn't find any fields in table 'sys_history'
Didn't find any fields in table 'sys_language'
Didn't find any fields in table 'sys_lockedrecords'
Didn't find any fields in table 'sys_log'
Didn't find any fields in table 'sys_note'
Didn't find any fields in table 'sys_preview'
Didn't find any fields in table 'sys_refindex'
Didn't find any fields in table 'sys_refindex_rel'
Didn't find any fields in table 'sys_refindex_res'
Didn't find any fields in table 'sys_refindex_words'
Didn't find any fields in table 'sys_template'
Didn't find any fields in table 'sys_workspace'
Didn't find any fields in table 'tt_content'
Didn't find any fields in table 'tx_impexp_presets'
Didn't find any fields in table 'tx_rtehtmlarea_acronym'
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
ERROR:
Can't connect to the server
mysql>