用户工具

站点工具


drupal:maitain:mysql-table-crashed

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 

参考

drupal/maitain/mysql-table-crashed.txt · 最后更改: 2013/05/01 10:36 (外部编辑)