Malc
Malc

Reputation: 13

Recovering MySQL data from external drive

AN older PC I was using has decided to give up completely but I've at least salvaged the HDD and mounted it on an external drive to the new Linux box (running Ubuntu Server 22.04). I'm trying to get the data off the old drive into the new installation so I can still work with the data on it. What's the easiest wary to get this done? (Me and MySQL have had many fallings out in the past!!) Thanks.

UPDATE I've copied across a folder from within the old mysql folder to the new one but it isn't listed in the lists of databases. I tried to create it in mysql but it told me the schema directory already exists, so at least I'm in the right place.

Upvotes: 0

Views: 101

Answers (1)

Malc
Malc

Reputation: 13

SOLVED! Copied out the new mysql folder and swapped in the entire new one. As I wanted a clean install I then dumped the databases I wanted and swapped the original folder back before importing the dumped sql files. Phew!

Upvotes: 1

Related Questions