mysql 拷贝数据库 表存在却打不开_InnoDB表存在于MySQL中,但表示在将数据库复制到新服务器后它们不存在...

“显示表格”的原因工作是因为mysqld只扫描数据库目录中的.frm文件.只要它们存在,它就会看到一个表定义.

如果您将数据导入MySQL并发生此错误消息,我将立即执行的第一件事是运行此命令：(BTW这是MySQL 5.1.45,但无论如何都在MySQL 5.x中工作)

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)

如果你导入数据的服务器说InnoDB被禁用,那么你有一个大问题.这是你应该做的：

1)从新导入数据库服务器中删除所有数据

3)运行SHOW ENGINES;并确保InnoDB完全正常运行！

4)将mysqldump重新加载到新的导入服务器中

试试看 ！！！