朋友一个天气预报网(http://tqybw.net)说网页打开不内容,让帮看下!
打开发过来的网址(http://tqybw.net/beijing15tian)页页提示错误:
tahblename Got error 134 from storage engine
判定这个是表出了问题,没办执行语句了
去mysql.com 找了下错误原因
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur:
The mysqld process is killed in the middle of a write.
An unexpected computer shutdown occurs (for example, the computer is turned off).
Hardware failures.
You are 找了下using an external program (such as myisamchk ) to modify a table that is being modified by the server at the same time.
A software bug in the MySQL or MyISAM code.
Typical symptoms of a corrupt table are:
You get the following error while selecting data from the table:
Incorrect key file for table: '...'. Try to repair it
Queries don't find rows in the table or return incomplete results.
详细来自:
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html
解决办法:
CHECK TABLE 表名
REPAIR TABLE 表名
分享到:
相关推荐
最近在执行一个innoDB类型sql文件的时候,发现系统报错了,通过查找相关的资料终于解决了,所以下面这篇文章主要给大家介绍了关于mysql执行sql文件时报错Error: Unknown storage engine 'InnoDB'的解决方法,需要的...
主要介绍了mysql数据库mysql: [ERROR] unknown option '--skip-grant-tables',需要的朋友可以参考下
MySQL 5.6 InnoDB Storage Engine Architecture
MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers By 作者: Jesper Wisborg Krogh ISBN-10 书号: 1484236939 ISBN-13 书号: 9781484236932 Edition 版本: 1st ed...
NULL 博文链接:https://314858770.iteye.com/blog/686136
MySQL错误代码以及出错信息对照大全
Jira6不支持mysql5.7,需要此jar,具体就是报错 Unknown system variable 'storage_engine' 的解决
环境变量配置错误 mysql 命令行错误 ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
user: ‘root’ host: `localhost’ (Got timeout reading communication packets) MYSQL server has gone away 引起这个原因是不可怕的.原因是更改了系统的断开时间. mysql>show gloable variables like “%time...
看下mysql目录的错误日志: 引用 090613 10:15:27 [ERROR] Default storage engine (InnoDB) is not available 090613 10:15:27 [ERROR] Aborting 090613 10:15:27 [Note] C:\www\mysql\bin\mysqld-nt: Shutdown ...
MySQL导入sql脚本错误:2006 – MySQL server has gone away 到如一些小脚本很少报错,但最近导入一个10+M的SQL脚本,却重复报错: Error occured at:2014-03-24 11:42:24 Line no.:85 Error Code: 2006 - MySQL ...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决: 1.打开在创建mysql容器时挂载的conf目录下的mysqld.cnf(如下文件) 我创建docker的姿势 2.进入mysqlId.cnf文件中在...
SequoiaSQL - MySQL Storage Engine is a distributed MySQL storage engine. It currently supports SequoiaDB 3.x as the backend database, and it will be extended to multiple databases such like MongoDB/...
Chapter 25: MySQL Storage Engines and Data Types Chapter 26: Securing MySQL Chapter 27: Using PHP with MySQL Chapter 28: Introducing PDO Chapter 29: Stored Routines Chapter 30: MySQL Triggers Chapter ...
Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned ...
lnmp安装(nginx mysql php )
mysql服务启动不了问题解决办法,文档描述,主要因数据文件损坏引起。