phpMyAdmin - #1932 Table doesn't exist (collation in use) after reinstalling
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.
Dolorosa
A newbie in web/mobile ui/ux development, data viz enthusiast.
Updated on June 04, 2022Comments
-
Dolorosa almost 2 years
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.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 messageP.S. I deleted line
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
from theconfig.inc.php
file before accessing my DB since it keep showing error message like this error message 2I've run out of idea about how to solve this. Any help appreciated. :)
-
Ahmad Afzaal over 7 yearsdelete folder xampp located in your C:\xampp