Apache Friends Support Forum

My Windows XP OS crashed on one of my computers and before I can reformat the hard drive it, I wanted to salvage my XAMPP MYSQL files. So I installed a fresh copy of XAMPP on another computer 'Drive C' and added the corrupt 'Drive D' to it on which my original MYSQL resides. So my question is what steps do I need to take to transfer my original MYSQL database on drive D to the new XAMPP installation on Drive C.

Tank you

Why don't you simply copy your entire D:\xampp\ folder?

Seems like I will have to do something like that, but not sure if it that simple.

It is.

Sure you could only copy over the MySQL data from D:\xampp\mysql\data\... but why?
Xampp saves all needed files and configurations to run inside the \xampp\ folder, so it is recommend to move the whole xampp folder.

Since I just installed the newer version of XAMPP , not sure if I will have compatibility problems copying the entire XAMPP folder of the older version, but maybe just the MSQL folder will do it

Maybe, maybe not. Chances decreasing the higher the version gap is. I would not try to achieve two goals (moving data and Xampp upgrade with just one step.

I would first move the entire Xampp folder and check it it is working. Only after that i would try to upgrade.

A full backup is always preferable to prevent data loss.

when I try to copy my old XAMPP folder over the new Intsalled XAMPP folder it does not allow it by saying cannot copy ib9a file since its being used by another person or program. And I cant erase it either.

When I manually copy Mysql/data file and open database with phpmyadmin, I do see the name of the name of the database and number of tables it holds, but I don't see the table data. How can I get the table data ?

nicoboy wrote:when I try to copy my old XAMPP folder over the new Intsalled XAMPP folder it does not allow it by saying cannot copy ib9a file since its being used by another person or program. And I cant erase it either.

Nobody said you should copy an old XAMPP over a new one. Uninstall the new one completely and move the entire \xampp\ folder.
If the path is different to the installation path in the past you need to execute the setup_xampp.bat script after that to rewrite the paths.
After that your XAMPP should work again.

If this is all running you plan how to upgrade to a new version. I would recommend to install the new xampp to a fresh folder, backup your databases with mysqldump command line script and import them to your new XAMPP installation.

I will give it a try over the weekend, thanks

I think that you solved your problem to use Long Path Tool