Page 1 of 1

Transferring /mysql to a new install

PostPosted: 30. September 2013 22:03
by mssteph
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

Re: Transferring /mysql to a new install

PostPosted: 30. September 2013 22:44
by originalhandy
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

Re: Transferring /mysql to a new install

PostPosted: 30. September 2013 22:46
by mssteph
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.

Re: Transferring /mysql to a new install

PostPosted: 01. October 2013 15:27
by mssteph
Still no luck. Can anyone point me in the right direction? The files seem to be there, they're just not showing in MyAdmin.

Re: Transferring /mysql to a new install

PostPosted: 02. October 2013 05:19
by Altrea
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