Mysql Server startet nicht mehr

[Pit910]

Hallo,

ich wollte eben meinen Mysql-Server neustarten, weil sich einige Tabellen im laufendem Betrieb nicht mehr abrufen ließen.

Jetzt startet der Server aber nicht mehr und das steht im Syslog:

Code: Alles auswählen

Dec  6 12:18:11 vps mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 [Note] Plugin 'FEDERATED' is disabled.
Dec  6 12:18:11 vps mysqld: /usr/sbin/mysqld: Table './mysql/plugin' is marked as crashed and last (automatic?) repair failed
Dec  6 12:18:11 vps mysqld: /usr/sbin/mysqld: Table 'plugin' is marked as crashed and last (automatic?) repair failed
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: The InnoDB memory heap is disabled
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Compressed tables use zlib 1.2.7
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Using Linux native AIO
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Initializing buffer pool, size = 128.0M
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Completed initialization of buffer pool
Dec  6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: highest supported file format is Barracuda.
Dec  6 12:18:11 vps mysqld: 141206 12:18:11  InnoDB: Waiting for the background threads to start
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 InnoDB: 5.5.40 started; log sequence number 35865429050
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 [Note] Server socket created on IP: '0.0.0.0'.
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 [ERROR] /usr/sbin/mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
Dec  6 12:18:12 vps mysqld: 141206 12:18:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
Dec  6 12:18:12 vps mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Dec  6 12:18:25 vps /etc/init.d/mysql[3660]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec  6 12:18:25 vps /etc/init.d/mysql[3660]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Dec  6 12:18:25 vps /etc/init.d/mysql[3660]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Dec  6 12:18:25 vps /etc/init.d/mysql[3660]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Dec  6 12:18:25 vps /etc/init.d/mysql[3660]: 

PS: Die Uhr geht falsch, anscheinend wegen Falscher Zeitzone.


Danke im Voraus!

[DeletedUserReAsG]

Und deine Frage lautet?

Anyway – wenn der automatische Reparaturversuch scheitert, und ein manueller ebenfalls, kann man wohl schon mal die Backups hervorkramen.

[Pit910]

Und deine Frage lautet?

Anyway – wenn der automatische Reparaturversuch scheitert, und ein manueller ebenfalls, kann man wohl schon mal die Backups hervorkramen.

Frage: Wie bekomme ich den Server wieder zum laufen

[Hendri]

Hallo,

also manuelle Reparatur wuerde wie folgt funktionieren:

Code: Alles auswählen

myisamchk /path/to/datadir/*/*.MYI

Ciao, Hendri