Restoring-importing MySQL data

  • 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

    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)

    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.