Restore MySQL schema from a snapshot of the data directory
Posted on 2013-05-24
Is it possible to restore MySQL schema from a snapshot of the data directory? I experienced corruption in one of my tables and I am having difficulty restoring my data from my only .SQL backup file (which file happens to be 8.5GB in size). I do have a snapshot of the data directory from a couple of days ago, but I can't seem to figure out how to connect to that directory. I have tried to modify the configuration file by simply changing the path to the datadir, but this does not work.