Apache Friends Support Forum

My Windows machine failed after an update and I could only take the XAMPP folder from C: for a wordpress site I was working on. I didn't have a chance to download the DB from phpMyAdmin but I have all the files. I understand how to move the theme from htdocs to the new one but I want to transfer the database as well and get back to where I left off. How do I do this?

[EDIT by Altrea: moved to the english section of this board]

If i were you i would make xampp temporarily running on windows again to dump a clean database export.
If you have the entire xampp folder this should be easily done.

I can't. I had to completely erase windows and install linux. And I don't have another machine with windows.

Try to copy c:/xampp/mysql/data (all contents from the data folder) to /opt/lampp/var/mysql. Previously move the contents of /opt/lampp/var/mysql to somewhere else. You also have to grant correct ownership and rights to the files coming from windows to linux (see ownership and rights of the files in /opt/lampp/var/mysql before you start the transfer).

That should work (not 100% sure, but its worth a try).

Nobbie wrote:Try to copy c:/xampp/mysql/data (all contents from the data folder) to /opt/lampp/var/mysql. Previously move the contents of /opt/lampp/var/mysql to somewhere else. You also have to grant correct ownership and rights to the files coming from windows to linux (see ownership and rights of the files in /opt/lampp/var/mysql before you start the transfer).

That should work (not 100% sure, but its worth a try).

I had to change the owner on the lmapp folder to do that or at least I thought I did. I swapped out all the contents into the correct folders and then changed the owner back to root. Now MySql won't start. The two others do. Any idea why?

WIthout any error message i cannot help further. Is there any error log or can you see any error message? Try to start mysqld from /opt/lampp/bin manually, maybe you get more info. Maybe you failed to grant correct ownership and rights. With the help of "sudo" there is no need to modify ownership of the lampp folder. Modify ownership with "sudo chown" and rights with "sudo chmod". Its very important to match the rights of the original files.

What i dont know - which Xampp version did you run on Windows? This binary transfer from Windows to Linux only works for same (or nearly same) releases of MySQL (MariaDB). If the Windows release was much older, the binary transfer wont have success. If you used a very old Xampp version, try to install same old linux version (you will find ALL Xampp releases on Sourceforge).

P.S.: This is the wrong forum, this forum is german language only (see above). There is also an english Xampp for Linux forum.

Sorry sorry I didn't notice I was on German language. Thanks for all the help.

PS. Imagine what the West would be today had we not been so concerned about being forced to be speak German

If nothing works out correctly - install VirtualBox on your Linux, download a Windows10 ISO Image from Microsoft, install it to the VirtualBox (you dont need to activate Windows, it will run without serial for a while) and finally copy your Xampp Installation to this Windows10 VirtualBox Installation. There is no need for another PC, neither for a Windows DVD.