朋友一个天气预报网(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文件时,如果系统报出“Error: Unknown storage engine 'InnoDB'”的错误,这意味着MySQL服务器无法识别或不支持InnoDB引擎。这通常是由于MySQL配置不当或InnoDB...
标题中的"StatementInvalid: Mysql::Error: query: not connected"是一个常见的MySQL错误,提示数据库连接已断开,用户在尝试执行查询时遇到了问题。这个错误通常发生在以下几种情况: 1. **数据库连接未建立**:在...
标题中的“Unknown system variable 'storage_engine'”是一个MySQL数据库错误信息,表示系统未找到名为'storage_engine'的变量。这个变量在MySQL 5.7版本中被弃用,替换为'innodb_storage_engine'。这通常是由于旧...
MySQL 5.6 InnoDB Storage Engine Architecture
在使用MySQL数据库时,可能会遇到一些配置问题或命令行参数错误导致的错误提示。此次,我们将详细解析关于MySQL数据库中出现的“未知选项‘--skip-grant-tables’”错误,并提供解决方案。 首先,“--skip-grant-...
看下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 命令行错误 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导入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 ...
- `0904179:02:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.` - `0904179:02:55 [ERROR] Unknown/unsupported table type: INNODB` - `0904179:02:55 [ERROR] Aborting` 这些错误信息表明...
2. 配置MySQL安全设置:`sudo mysql_secure_installation` 3. 设置root用户的密码,移除匿名用户,禁止root远程登录,以及删除测试数据库。 安装PHP(Hypertext Preprocessor),它是服务器端的脚本语言,常用于...
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 ...
Mysql主从同步的Last_IO_Errno:1236...Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configur
【MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error】是一个常见的MySQL服务器启动时遇到的问题。这个问题通常表明MySQL的InnoDB存储引擎无法获取对`ibdata1`文件的锁,`ibdata1`是InnoDB用来存储数据和系统表...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决: 1.打开在创建mysql容器时挂载的conf目录下的mysqld.cnf(如下文件) 我创建docker的姿势 2.进入mysqlId.cnf文件中在...
innodb storage engine architecture innodb存储引擎架构