After xampp upgrade problem with MySQL

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

After xampp upgrade problem with MySQL

Postby brandozz » 17. May 2013 16:11

I just recently upgraded my version of xampp and I'm receiving a SQL error in phpmyadmin. I copied all of my sites and my databases before upgrading. Uninstalled the old version then re-installed the new version. Copied my old "data" folder into the "mysql" folder.

When I log into phpmyadmin I see the following error in the left had sidebar:

SELECT `tables`
FROM `phpmyadmin`.`pma_recent`
WHERE `username` = 'root'

MySQL said:

#1146 - Table 'phpmyadmin.pma_recent' doesn't exist

I can see my databases but my wordpress site is having some issues connecting to it.
brandozz
 
Posts: 6
Joined: 17. May 2013 15:42
Operating System: Windows

Re: After xampp upgrade problem with MySQL

Postby Altrea » 17. May 2013 16:13

Don't copy ALL databases from an old installation over to a new one.
Applications like phpmyadmin will change and it's databases too.
Just copy over your own databases youself created.
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After xampp upgrade problem with MySQL

Postby brandozz » 17. May 2013 16:17

I knew I should have backed up that data folder in the new install before clearing it out.

Thanks for the tip.
brandozz
 
Posts: 6
Joined: 17. May 2013 15:42
Operating System: Windows

Re: After xampp upgrade problem with MySQL

Postby brandozz » 17. May 2013 16:59

I copied my database folder into my new mysql -> data folder but when I open phpmyadmin it doesn't show my tables. Is there another step that I'm missing?
brandozz
 
Posts: 6
Joined: 17. May 2013 15:42
Operating System: Windows


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 1 guest