====== Drupal Mysql数据库表格Crash ====== ===== Drupal mysql 数据库Crash问题描述 ===== 今天打开我的博客 (http://www.truevue.org/),发现有一条出错信息: ./truevue/truevue_accesslog is marked as crashed and last (automatic?) repair failed query: INSERT INTO truevue_accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values ....... ===== Mysql数据库表格出错解决方法 ===== 发现可能是数据库出错,Google一下,在 stackoverflow上面找的了方法: - Go to your data folder and try running myisamchk -r . - You should stop MySQL process first. - If that doesn't work, you can try with myisamchk -r -v -f . ===== Mysql数据库默认安装路径 ===== 如果安装mysql的时候没有修改,那么mysql数据库默认安装路径为 /var/lib/mysql ===== 参考 ===== * http://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed