Salvaging Xampp MYSQL Database from one drive to another on

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

Salvaging Xampp MYSQL Database from one drive to another on

Postby nicoboy » 09. July 2015 17:43

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
nicoboy
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby Altrea » 09. July 2015 20:26

Why don't you simply copy your entire D:\xampp\ folder?
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby nicoboy » 09. July 2015 20:29

Seems like I will have to do something like that, but not sure if it that simple.
nicoboy
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby Altrea » 09. July 2015 20:33

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.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby nicoboy » 09. July 2015 20:40

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
nicoboy
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby Altrea » 09. July 2015 22:22

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.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby nicoboy » 10. July 2015 04:28

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.
nicoboy
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby nicoboy » 10. July 2015 04:39

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
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby Altrea » 10. July 2015 13:46

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.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby nicoboy » 10. July 2015 19:39

I will give it a try over the weekend, thanks
nicoboy
 
Posts: 6
Joined: 09. July 2015 17:39
Operating System: xp

Re: Salvaging Xampp MYSQL Database from one drive to another

Postby joshua42 » 23. October 2015 05:30

I think that you solved your problem to use Long Path Tool
joshua42
 
Posts: 1
Joined: 23. October 2015 05:27
Operating System: window7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests