Recover MySQL Database
-
@scottalanmiller, any ideas?
-
VSS is actually the Windows "late to the party" copy of LVM on Linux. Linux was doing this and it was a standard "ha ha, Windows lacks this feature" that forced them to add VSS into Windows. LVM can do snapshots.
On FreeBSD and Solaris you can do the same thing with ZFS.
-
@scottalanmiller said:
VSS is actually the Windows "late to the party" copy of LVM on Linux. Linux was doing this and it was a standard "ha ha, Windows lacks this feature" that forced them to add VSS into Windows. LVM can do snapshots.
On FreeBSD and Solaris you can do the same thing with ZFS.
So how would I do what I am trying to do here?
-
@handsofqwerty said:
@scottalanmiller said:
VSS is actually the Windows "late to the party" copy of LVM on Linux. Linux was doing this and it was a standard "ha ha, Windows lacks this feature" that forced them to add VSS into Windows. LVM can do snapshots.
On FreeBSD and Solaris you can do the same thing with ZFS.
So how would I do what I am trying to do here?
Same as VSS. Set it up to run BEFORE you overwrite stuff. Like any backup or snapshot, you can't turn it on later and magically get stuff that hasn't been backed up or snapshotted yet.
-
@scottalanmiller said:
@handsofqwerty said:
@scottalanmiller said:
VSS is actually the Windows "late to the party" copy of LVM on Linux. Linux was doing this and it was a standard "ha ha, Windows lacks this feature" that forced them to add VSS into Windows. LVM can do snapshots.
On FreeBSD and Solaris you can do the same thing with ZFS.
So how would I do what I am trying to do here?
Same as VSS. Set it up to run BEFORE you overwrite stuff. Like any backup or snapshot, you can't turn it on later and magically get stuff that hasn't been backed up or snapshotted yet.
I know that principle. Is it on by default? How do you enable it so I can prevent this in the future?
-
No, it is not on my default. You don't want snapshots by default. You need to make sure that you have installed on LVM first. Then configure it to snapshot.
-
-
If you do an lvs command it will show you the current state of your LVMs. Many systems do not install LVM by default.
-
This thread has nothing to do with recovering a MySQL database.
You are attempting to revert file system changes to recover a changed database. this is completely different.
-
MySQL seems to be completely hosed. I'm going to have to rebuild the server, as restoring from backups even a week ago, even at the VM level, is not working!
