phpMyAdmin-#1932重新安装后表不存在(正在使用排序规则) [英] phpMyAdmin - #1932 Table doesn't exist (collation in use) after reinstalling

问题描述

当我发现XAMPP服务器收到一些错误日志时，我正在做论文，因此我决定将XAMPP重新安装到较新的版本(我是从SO中的某些线程得到这个想法的).我移动了mysql > data文件夹，并再次将其还原到新的安装文件夹中.

I'm in the middle of doing my thesis when I found my XAMPP server got some error logs, so I decide to reinstall my XAMPP to a newer version (I got this idea from some threads in SO). I moved my mysql > data folder and restored it again in my new installation folder.

但是，当我访问phpMyAdmin并尝试在数据库中执行一些操作时，我得到了这一点(以前我从未见过使用collation列): 错误消息

However when I accessed phpMyAdmin and tried to do some operations in my DB I got this (I've never seen my collation column is in use before): error message

P.S.在访问数据库之前，我已从config.inc.php文件中删除了行$cfg['Servers'][$i]['tracking'] = 'pma__tracking';，因为它一直显示这样的错误消息，例如错误消息2

P.S. I deleted line $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; from the config.inc.php file before accessing my DB since it keep showing error message like this error message 2

我对如何解决这个问题已经无所适从.任何帮助表示赞赏. :)

I've run out of idea about how to solve this. Any help appreciated. :)

推荐答案

好，所以我找到了自己的解决方案

Ok, so I found my own solution here. Moving database files is kinda tricky, and supposedly I don't remove any old logfiles since they are important for any further access.

这篇关于phpMyAdmin-#1932重新安装后表不存在(正在使用排序规则)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！