#1146 -表XXXX不存在 [英] #1146 -Table XXXX doesn't exist

问题描述

我使用 phpmyadmin v4.1.14 Apache 版本 2.4.9.
在我的 wamp 损坏后，我复制了 wamp 的整个文件夹并安装了具有相同版本的新文件夹.

I use phpmyadmin v4.1.14 Apache version 2.4.9.
After my wamp corrupt I copy the whole folder of wamp and install the new one with the same version.

我替换了所有文件夹，期望 wampmanager.ini 已损坏，但是在转到 phpmyadmin 后，单击任何表后，所有数据库都没有显示任何数据错误:

I replace all the folder expect wampmanager.ini which was corrupted, but after going to phpmyadmin, all databases don't show any data with error after click any table:

#1146 -表 XXXX 不存在

#1146 -Table XXXX doesn't exist

我尝试在这里阅读一些答案，但不起作用.

I try to read some answers here but not working.

推荐答案

wampmanager.ini 每次启动 WAMPServer 以及执行刷新 时都会重新创建从菜单.

wampmanager.ini is re-created every time you start WAMPServer, and when you do a refresh from the menu.

如果 wampmanager.ini 确实已损坏，那么很可能wampmanager.tpl 确实已损坏，因为该文件已被使用通过wampmanager.exe重建wampmanager.ini

If wampmanager.ini was really corrupted, then it is most likely that wampmanager.tpl was actually corrupted, as that file is used by wampmanager.exe to rebuild wampmanager.ini

然而，除非有人一直在使用 wampmanager.tpl 文件，否则任何一个文件都很少被损坏.如果您尝试更改 wampmanager.tpl 的副本，请始终获取它的副本，以便您可以通过恢复副本返回到工作系统.

However, it is rare for either file to get corrupted unless someone has been playing with the wampmanager.tpl file. Always take a copy of wampmanager.tpl if you are trying to change it, so you can get back to a working system by restoring your copy.

恢复备份

简单的方法.

如果您认为新安装所需的只是 \wampmanager.tpl 和 wampmanager.ini，那么这是一个更简单的解决方案

If all you think you need from the new install is the \wampmanager.tpl and wampmanager.ini then this is a simpler solution

在您新安装的 WAMPServer 上:

On your new install of WAMPServer:

使用 wampmanager 菜单，执行

Using the wampmanager menus, do

(right click)wampmanager-> Apache-> Service->Remove service
(right click)wampmanager-> MYSQL-> Service-> Remove service
(left click) wampmanager-> exit

WAMPServer 基本卸载了，但没有删除任何文件

WAMPServer is basically uninstalled, but no files have been deleted

rename C:\wamp\ to C:\wamp_new

现在恢复您备份的 WAMPServer 版本

Now restore your backed up version of WAMPServer

copy c:\backup_wamp to C:\wamp

现在从新安装中取出您认为已损坏的 2 个文件，并将它们放置在恢复的原始 WAMPServer 中

Now pick up the 2 files you think are corrupted from the new install and place them in the restored original WAMPServer

copy c:\wamp_new\wampmanager.tpl to c:\wamp\wampmanager.tpl
copy c:\wamp_new\wampmanager.ini to c:\wamp\wampmanager.ini

启动 WAMPServer

Start WAMPServer

现在重新注册Apache和MYSQL服务

Now re-register the Apache and MYSQL services

(right click)wampmanager-> Apache-> Service-> Install service
(right click)wampmanager-> MYSQL-> Service-> Install service

要确保正确重建 SYMLINKS，请执行

To make sure the SYMLINKS are correctly rebuilt do

(right click)wampmanager-> Apache-> Version-> 2.4.9 (click on the 2.4.9) 

or whatever version you are using

您的旧 WAMPServer 现在应该重新安装，但使用新版本的 wampmanager.ini 和 wampmanager.tpl

Your old WAMPServer should now be reinstalled, but with the new versions of the wampmanager.ini and wampmanager.tpl

如果这不起作用，您没有以任何方式更改原始备份，但您应该回到安装新 WAMPServer 之前的位置，但替换了您认为已损坏的 2 个文件.

If this does not work, you have not changed your original backup in any way, but you should be back where you were before installing the new WAMPServer, but having replaced the 2 files you think were corrupted.

如果这不能让你的旧数据库完好无损，那么你没有做完整的备份，我担心你的数据库很可能会永远丢失.

If this does not come up with your old database intact, then you did not make a complete backup, and I am afraid your database may well be lost for ever.

如果一切正常您可以删除C:\wamp_new文件夹以避免以后混淆

If all works you can delete the C:\wamp_new folder to avoid confusion later

这篇关于#1146 -表XXXX不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！