Transferring /mysql to a new install

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

Transferring /mysql to a new install

Postby mssteph » 30. September 2013 22:03

Hi, I installed an updated version of XAMPP by moving /htdocs and /mysql to a new folder, uninstalling XAMPP, and installing an updated version. I've moved all my saved /htdocs files to XAMPP, but just moving the /mysql folder to my new install doesn't recreate all the databases. I've clearly made... a huge mistake here, by not backing up each database, but is there any way to restore these databases with an exported db file?

Any help is much appreciated. Thanks.

Steph
mssteph
 
Posts: 3
Joined: 30. September 2013 21:58
XAMPP Version: 5.5.19
Operating System: Windows 7

Re: Transferring /mysql to a new install

Postby originalhandy » 30. September 2013 22:44

I had to change the auth to cookie and log in as root to fix mine. Search for a thread I started on somethin similar and see if it helps. I'm not at a pc to get the link

Edit:
I just saw this is Windows and mine was Linux, not sure if itll work.

Sent from my SGH-T989 using Tapatalk 2
originalhandy
 
Posts: 5
Joined: 24. September 2013 04:47
XAMPP Version: 1.8.3-3
Operating System: openSUSE 11.4 (i586)

Re: Transferring /mysql to a new install

Postby mssteph » 30. September 2013 22:46

originalhandy wrote:I had to change the auth to cookie and log in as root to fix mine. Search for a thread I started on somethin similar and see if it helps. I'm not at a pc to get the link

Sent from my SGH-T989 using Tapatalk 2


Thanks, I'll try to find it.
mssteph
 
Posts: 3
Joined: 30. September 2013 21:58
XAMPP Version: 5.5.19
Operating System: Windows 7

Re: Transferring /mysql to a new install

Postby mssteph » 01. October 2013 15:27

Still no luck. Can anyone point me in the right direction? The files seem to be there, they're just not showing in MyAdmin.
mssteph
 
Posts: 3
Joined: 30. September 2013 21:58
XAMPP Version: 5.5.19
Operating System: Windows 7

Re: Transferring /mysql to a new install

Postby Altrea » 02. October 2013 05:19

If you are logged in to phpmyadmin, please execute the following two statements in your SQL tab and report back what the outputs are:
Code: Select all
SELECT CURRENT_USER()

Code: Select all
SHOW GRANTS
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: 6829
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 40 guests