Home > Database > Mysql Tutorial > Mysql中Table ‘XXX’ is marked as crashed and last (automati_MySQL

Mysql中Table ‘XXX’ is marked as crashed and last (automati_MySQL

WBOY
Release: 2016-06-01 13:14:55
Original
1324 people have browsed it

网站的 MYSQL 数据库出现错误如下提示:
Table ‘./dede_archives' is marked as crashed and last (automatic?)
该问题即为相关表受到损坏,一般情况下,可以用 phpmyadmin 对该表进行修复。
如果是独立的服务器,也可使用命令行方式进行修复。修复前将mysql服务停止:
/etc/init.d/mysqld stop
然后执行如下命令(参考)修复该表:
myisamchk -r /usr/local/mysql/var/dede/dede_archives.MYI
注意数据库表所在路径。 win 主机下可类比执行。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template