Error when accessing the databases in phpMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error when accessing the databases in phpMyAdmin

Postby harkon » 19. March 2016 18:18

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?
harkon
 
Posts: 7
Joined: 11. February 2016 22:19
Operating System: Windows

Re: Error when accessing the databases in phpMyAdmin

Postby Altrea » 19. March 2016 19:53

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Error when accessing the databases in phpMyAdmin

Postby harkon » 19. March 2016 20:40

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?
harkon
 
Posts: 7
Joined: 11. February 2016 22:19
Operating System: Windows

Re: Error when accessing the databases in phpMyAdmin

Postby Altrea » 19. March 2016 21:23

yes
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Error when accessing the databases in phpMyAdmin

Postby harkon » 19. March 2016 22:25

Thank you. It's working.
harkon
 
Posts: 7
Joined: 11. February 2016 22:19
Operating System: Windows

Re: Error when accessing the databases in phpMyAdmin

Postby Altrea » 20. March 2016 05:13

You are welcome :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 29 guests