phpMyAdmin - #1932 Table doesn't exist (collation in use) after reinstalling

19,647

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.

Share:
19,647
Dolorosa
Author by

Dolorosa

A newbie in web/mobile ui/ux development, data viz enthusiast.

Updated on June 04, 2022

Comments

  • Dolorosa
    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 message

    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. :)

  • Ahmad Afzaal
    Ahmad Afzaal over 7 years
    delete folder xampp located in your C:\xampp