Mysql一直显示等待中_在线等待中！！mysql的问题

我在创建表的过程中强制关闭数据库，结果出现了以下问题，希望大家能帮帮忙，在线等。错误如下：

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 314  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 311  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 308  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 310  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 309  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 300  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 284  user: 'gh'

070719 14:19:58 [Warning] C:\mysql50\bin\mysqld-nt: Forcing close of thread 263  user: 'gh'

070719 14:19:58  InnoDB: Starting shutdown...

070719 14:20:00  InnoDB: Shutdown completed; log sequence number 13 4206832401

070719 14:20:00 [Note] C:\mysql50\bin\mysqld-nt: Shutdown complete

070719 14:23:35  InnoDB: Started; log sequence number 13 4206832401

070719 14:23:36 [Note] C:\mysql50\bin\mysqld-nt: ready for connections.

Version: '5.0.19-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

070719 14:23:36070719 14:23:36 [ERROR] Cannot find table netmgr/prob_info from the internal data dictionary

of InnoDB though the .frm file for the table exists. Maybe you

have deleted and recreated InnoDB data files but have forgotten

to delete the corresponding .frm files of InnoDB tables, or you

have moved .frm files to another database?

Look from section 15.1 of http://www.innodb.com/ibman.html

how you can resolve the problem.

070719 14:23:36070719 14:23:36 [ERROR] Cannot find table netmgr/prob_info from the internal data dictionary

of InnoDB though the .frm file for the table exists. Maybe you

have deleted and recreated InnoDB data files but have forgotten

to delete the corresponding .frm files of InnoDB tables, or you

have moved .frm files to another database?

Look from section 15.1 of http://www.innodb.com/ibman.html

how you can resolve the problem.

.......

接着把备份的数据copy到data目录下，但数据库下没有表的字段，也没有数据。

作者: anderolujun

发布时间: 2007-07-19