Problem with database transfer after PC crash

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

Problem with database transfer after PC crash

Postby Krx » 02. January 2014 17:31

Hello

I have 2 problems:

On my old PC Win 7 pro 64 machine, I had XAMPP v 1.7.7 installation with approx 200 databases. PC crashed so I was unable to do proper DB export
Now I have new Win 8.1 pro 64 machine and I'm trying to restore my webs from old disk into new 1.8.2 Xampp installation

Is it possible to import old mysql data into new XAMPP installation?
Folder stricture is the same, and I still have access to all xampp files on old disk

At 1st - I tried to just copy data folders from mysql folder into new one, but webs doesn't work because I didn't copied mysql files from data folder root, just data website named folders.

Than I copied (synced with total commander) all files from old data folder root, and now websites work,
but because it over-writed files in new data root folder Im guessing that some some tables from new xampp version might be lost.

So I tried to do xampp reinstall but it doesn't wont to proceed, it says Xampp directory is not empty.

What would be the best way to transfer just my websites mysql data into new xampp environment?

Thanks
Best Regards
Krx
 
Posts: 3
Joined: 02. January 2014 17:10
Operating System: Win 8.1 pro 64

Re: Problem with database transfer after PC crash

Postby GameplayJDK » 02. January 2014 17:44

I know, that there is an option to import Databases from another server in phpMyAdmin..
But I never had to use it
Some bugs are Features, and some are not. Of which kind a bug is, depends on your point of view :D
GameplayJDK
 
Posts: 8
Joined: 02. January 2014 14:25
Operating System: Windows 8.1 Pro

Re: Problem with database transfer after PC crash

Postby Altrea » 02. January 2014 20:26

Hi Krx,

Krx wrote:On my old PC Win 7 pro 64 machine, I had XAMPP v 1.7.7 installation with approx 200 databases. PC crashed so I was unable to do proper DB export
Now I have new Win 8.1 pro 64 machine and I'm trying to restore my webs from old disk into new 1.8.2 Xampp installation

Why don't you first rebuild your XAMPP 1.7.7 on your new OS? This would be much less trouble and you can do proper database exports.

Krx wrote:Is it possible to import old mysql data into new XAMPP installation?
Folder stricture is the same, and I still have access to all xampp files on old disk

Difficult to say, we don't know your databases. MyISAM is quite easy to restore, there are three files that define a whole database. InnoDB could make much more trouble.
So, copying your own Database folders (NOT folders like mysql, information_schema, etc) into the new MySQL data folder can maybe be successful, but don't have to. A clean database export is always preferable.

Krx wrote:So I tried to do xampp reinstall but it doesn't wont to proceed, it says Xampp directory is not empty.

Then do a full uninstall first (if needed delete fragments of the xampp folder at the end by yourself).

Krx wrote:What would be the best way to transfer just my websites mysql data into new xampp environment?

First have a running environment again (XAMPP 1.7.7) then install the current XAMPP version side by side. Do clean database dumps and restore them in your new environment.

best wishes,
Altrea

P.S.:
GameplayJDK wrote:I know, that there is an option to import Databases from another server in phpMyAdmin..
But I never had to use it

A function that can restore whole databases from just the source folders? I don't think that such a function exists.
You can import dump files like .sql or .csv, or make use of replication functionality if you have two running MySQL servers.
But none of them will fit for this problem here.
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: 8297
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests