error on optimize and repair all databases
MySQL crashed and too many databases need to be repair.
Sample logs:
I started to check and repair all databases by following line:
Everything is fine (from A-T) till "test_db", Then process stop by following error:
Whats wrong and how can resolve this problem? NOTE: mysql "innodb_force_recovery" set to zero. Databases only working fine on "innodb_force_recovery = 0" Any idea?
2016-02-05 16:08:31 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:31 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:32 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:32 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:32 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:32 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:32 19683 [ERROR] /usr/sbin/mysqld: Table './markerd_mtn/mtn_session' is marked as crashed and should be repaired
2016-02-05 16:08:34 19683 [ERROR] /usr/sbin/mysqld: Table './guilansa_jolnew/in7e0_session' is marked as crashed and should be repaired
2016-02-05 16:08:34 19683 [ERROR] /usr/sbin/mysqld: Table './guilansa_jolnew/in7e0_session' is marked as crashed and should be repaired
2016-02-05 16:08:34 19683 [ERROR] /usr/sbin/mysqld: Table './guilansa_jolnew/in7e0_session' is marked as crashed and should be repaired
2016-02-05 16:08:34 19683 [ERROR] /usr/sbin/mysqld: Table './guilansa_jolnew/in7e0_session' is marked as crashed and should be repaired
2016-02-05 16:09:02 19683 [ERROR] /usr/sbin/mysqld: Table './kimiasan_nprz/nprz_session' is marked as crashed and should be repaired
2016-02-05 16:09:02 19683 [ERROR] /usr/sbin/mysqld: Table './kimiasan_nprz/nprz_session' is marked as crashed and should be repaired
2016-02-05 16:09:02 19683 [ERROR] /usr/sbin/mysqld: Table './kimiasan_nprz/nprz_session' is marked as crashed and should be repaired
2016-02-05 16:09:02 19683 [ERROR] /usr/sbin/mysqld: Table './kimiasan_nprz/nprz_session' is marked as crashed and should be repaired
2016-02-05 16:09:02 19683 [ERROR] /usr/sbin/mysqld: Table './kimiasan_nprz/nprz_session' is marked as crashed and should be repaired
2016-02-05 16:10:50 19683 [ERROR] /usr/sbin/mysqld: Table './hydrop_power/hydro_session' is marked as crashed and should be repaired
2016-02-05 16:10:50 19683 [ERROR] /usr/sbin/mysqld: Table './hydrop_power/hydro_session' is marked as crashed and should be repairedI started to check and repair all databases by following line:
mysqlcheck -u root -p --auto-repair --optimize --all-databasesEverything is fine (from A-T) till "test_db", Then process stop by following error:
mysqlcheck: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`com`' at line 1 when executing 'OPTIMIZE TABLE ... 'Whats wrong and how can resolve this problem? NOTE: mysql "innodb_force_recovery" set to zero. Databases only working fine on "innodb_force_recovery = 0" Any idea?
-
Hello :) Is this an actual database or is it a test database? You could try backing up the database with the "mysqldump" utility: MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump " A Database Backup Program Then, remove it, run the "repair" command again, and restore the database. Thank you. 0
Please sign in to leave a comment.
Comments
1 comment