Restoring-importing MySQL data | ww.wp.xz.cn

JohnL
(@johnl)

8 years, 11 months ago

Mea culpa: Bad backup up behavior. I had a disk crash. All I have left of my MySQL data is the /data contents.

Does anyone know whether (and how) I can simply dump those files into the /data directory of a /mysql/data directory of a new machine and go on my merry way?

Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

8 years, 11 months ago

I’ll give you a qualified “perhaps”. Stop your mysql server, put the old files in place and restart. They run mysqlcheck.

Thread Starter JohnL
(@johnl)

8 years, 11 months ago

Steve, thanks for the definite maybe. From what I found at StackOverFlow, I’m thinking your analysis might be right:

https://stackoverflow.com/questions/22068010/how-to-merge-two-mysql-databases-of-same-structure.

I think I’ll stop the server, copy the data directory from the existing good MySQL instance as a back up, drop the tables from my lost server into the existing data directory, and restart…using mysqlcheck (about which I’ll have to read before I proceed).

Being only a light-weight MySQL jock, I’m a little skittish. Thanks again.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Restoring-importing MySQL data’ is closed to new replies.

Tags

In: Fixing WordPress
2 replies
2 participants
Last reply from: JohnL
Last activity: 8 years, 11 months ago
Status: not resolved

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics