无法在phpmyadmin中打开一些表

Recently i get backup of my database from host in that backup i get table in .ibd,.frm,.myd format .

最近我从主机备份我的数据库备份我得到.ibd，.frm，.myd格式的表。

I placed this files in

我把这些文件放进去了

xampp->mysql->data->test

xampp-> mysql-> DATA->测试

. Now i can open the tables in php myadmin. Now i can open some tables .But some files i can not open . When clicked it showing 932 - Table 'table.name' doesn't exist in engine . And also i noticed in the collection column it is showing in use

。现在我可以在php myadmin中打开表格了。现在我可以打开一些表。但是有些文件无法打开。单击它时显示932 - 表'table.name'在引擎中不存在。而且我在收集栏中注意到它正在使用中

Why this happen . Please help to solve

为什么会这样。请帮忙解决

1 个解决方案

#1

As I understand it, your remote host machine crashed, and all they could recover was the database table files.

据我了解，您的远程主机崩溃了，他们可以恢复的只是数据库表文件。

Now these really aren't meant to be moved, written to or read from by anything other than the very database engine that created them. Any attempt to do so is not guaranteed to work. But as you're left with no alternatives, we're going to have to try anyway. You started off well, I think, by trying to read the files into a local database engine. The problems you're having may be to do with two important differences:

现在，这些实际上并不意味着被创建它们的数据库引擎移动，写入或读取。任何这样做的尝试都不能保证有效。但是，由于你没有其他选择，我们无论如何都要尝试。我认为，你开始尝试将文件读入本地数据库引擎。你遇到的问题可能与两个重要的区别有关：

The version of MySQL you're running locally vs. the one running remotely.
您在本地运行的MySQL版本与远程运行的MySQL版本。
The Operating System locally vs. remote.
本地操作系统与远程操作系统。

Both you can fix easily. I would get these out of the way first, to exclude them as potential sources of trouble.

两者都可以轻松修复。我会首先将这些排除在外，将它们排除在潜在的麻烦之中。

So install VMware or VirtualBox on your machine, and recreate a guest VM with the same OS as the one provided by your hosting provider. Then install onto that VM the same version of MySQL that also runs on your remote host.

因此，请在您的计算机上安装VMware或VirtualBox，并使用与托管服务提供商提供的操作系统相同的操作系统重新创建来宾VM。然后在该VM上安装也在远程主机上运行的相同版本的MySQL。

Also, I repeat what I said earlier: look out for an alternative to your current hosting provider to fall back on, and as long as your hosting provider can't guarantee the safety and integrity of your data, you must be prepared to make frequent backups yourself.

此外，我重复我之前所说的内容：寻找替代当前托管服务提供商的替代方案，只要您的托管服务提供商无法保证数据的安全性和完整性，您必须做好准备自己备份。

1 个解决方案

#1

更多相关文章

随机推荐