目录

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上面找的了方法:

  1. Go to your data folder and try running myisamchk -r <table_name>.
  2. You should stop MySQL process first.
  3. If that doesn't work, you can try with myisamchk -r -v -f <table_name>.

Mysql数据库默认安装路径

如果安装mysql的时候没有修改,那么mysql数据库默认安装路径为

/var/lib/mysql 

参考