====== 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