论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-07-22 16:15 |只看该作者 |倒序浏览

数据库关闭。做数据备份。

所有表使用的都是 MyISAM Engine。

数据库启动：
[root@localhost HBUNICOM]# /bin/sh /usr/bin/mysqld_safe --user=mysql
110722 14:13:32 mysqld_safe Logging to '/XX_COM/mysqldata/mysqlroot/localhost.localdomain.err'.
110722 14:13:32 mysqld_safe Starting mysqld daemon with databases from /XX_COM/mysqldata/mysqlroot

[root@localhost mysqlroot]# tail -F /XX_COM/mysqldata/mysqlroot/localhost.localdomain.err

110722 14:08:39 mysqld_safe mysqld from pid file /XX_COM/mysqldata/mysqlroot/localhost.localdomain.pid ended
110722 14:13:32 mysqld_safe Starting mysqld daemon with databases from /XX_COM/mysqldata/mysqlroot
110722 14:13:32 [Note] Plugin 'FEDERATED' is disabled.
110722 14:13:32  InnoDB: Started; log sequence number 0 69471
110722 14:13:32 [Note] Event Scheduler: Loaded 0 events
110722 14:13:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.39-community-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

[root@localhost mysqlroot]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 80
Server version: 5.1.39-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use prepayed;
Database changed

遇到的问题：只有2个表出现下面这个问题。其它的表都可以正常打开。

mysql> select * from hb_staff_count;
ERROR 1030 (HY000): Got error 140 from storage engine

mysql> desc hb_staff_count;
ERROR 1030 (HY000): Got error 140 from storage engine

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine    | Support | Comment                                                       | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB    | YES    | Supports transactions, row-level locking, and foreign keys    | YES       | YES  | YES       |
| MRG_MYISAM | YES    | Collection of identical MyISAM tables                         | NO          | NO | NO       |
| BLACKHOLE  | YES    | /dev/null storage engine (anything you write to it disappears) | NO          | NO | NO       |
| CSV       | YES    | CSV storage engine                                           | NO          | NO | NO       |
| MEMORY    | YES    | Hash based, stored in memory, useful for temporary tables    | NO          | NO | NO       |
| FEDERATED  | NO    | Federated MySQL storage engine                               | NULL       | NULL | NULL    |
| ARCHIVE | YES    | Archive storage engine                                        | NO          | NO | NO       |
| MyISAM    | DEFAULT | Default engine as of MySQL 3.23 with great performance       | NO          | NO | NO       |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)