Page 1 of 1

Error when accessing the databases in phpMyAdmin

PostPosted: 19. March 2016 18:18
by harkon
I just updated my XAMPP in order to move from PHP 5.6 to PHP 7 but now I have a problem with accessing the old databases through phpMyAdmin. Whenever I click on a database, I get the following error:

MySQL said: Documentation

#1932 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist in engine


I also receive the following notice:

Create missing phpMyAdmin configuration storage tables.


How can I solve this issue?

Re: Error when accessing the databases in phpMyAdmin

PostPosted: 19. March 2016 19:53
by Altrea
Don't copy over the old databases. Backup only your own databases and not the mysql, phpmyadmin or any other database you don't created your own.

Copying over an Xampp Installation over another will result in many cases in an corrupt installation.

Re: Error when accessing the databases in phpMyAdmin

PostPosted: 19. March 2016 20:40
by harkon
Do you mean I should export all the databases that I've created in the old installation through phpMyAdmin and then import them after I finish installing the new version of Xampp again through phpMyAdmin?

Re: Error when accessing the databases in phpMyAdmin

PostPosted: 19. March 2016 21:23
by Altrea
yes

Re: Error when accessing the databases in phpMyAdmin

PostPosted: 19. March 2016 22:25
by harkon
Thank you. It's working.

Re: Error when accessing the databases in phpMyAdmin

PostPosted: 20. March 2016 05:13
by Altrea
You are welcome :D