Discussion in 'Testing One Another's Backups' started by Dan Allen, Jan 17, 2016.
View attachment 1065
So now, finally we can try restoring stepping up from the backup on backup and see if it works. Here is how to restore a db from that kind of backup
Now populated after the database restore
Only one mySQL server per machine. That is why all the databases for Mac Haik, both live and dev, had to be in the same phpMyAdmin application.
This is a really good walkthrough! Thank you for posting all this.
I am wanting the material I am creating on this forum to become valuble content to drip.
I was hoping I had tricked you into losing track of that vital fact.
Just another spot check. I know you have seen notes on how Linux is able to keep only one copy of files and track all the places the file is used to save disk space. If it were not for this, this level of backup would be using more than a Terabyte instead of 82G
hwctt=holly's writing classes at Tiger Tech
I've given all this a closer look, and I have a few questions, and a few things I want to make sure that I got right.
I understand what you did with making 'HotRoll' a copy of the original steppingup db, just in case something went wrong with the restoration from your backup. That was pretty cool, and I could see how that all went.
The only thing that wasn't quite clear to me was the order of the backups. It appeared to me that the backup with the HotRoll copy came before the backup with just the steppingup db. Because of this discrepancy, I know there is something I am missing, I just don't know what it is.
Here's the screenshot with my comments:
I understand that the snapshots of the databases would take up as much space as the whole db for each backup because the files change so frequently (every second apparently). That is why there are two hours worth of hourly backups instead, of which the oldest is replaced by the newest backup on the third hour.
With snapshots in Linux, does replacing the old file with the new version delete the old version completely? Or can you dial back to the old version by rolling back to a point where it existed in the old state? In fact, I think after another read through I've answered my own question, when I read what you wrote about Linux keeping only one copy of each unique version of the file.
I also had a quick question about copying the database from the backup. (The screenshots with the actual commands on them are excellent btw.) I know that cp is the copy command, but what is 'scp'? Is it a special version of cp?
I think that's all I have for now.
This walkthrough is excellent, and the screenshots are part of what make it so great. The only thing to watch for would be to make sure the images of the phpMyAdmin (shots #6 and 7 as you scroll down) are clear enough, because at the resolution of my screen the numbers on the columns are hard to read, and for some reason I was unable to make them larger like some of the other screen shots.
Also, are the backups of the old phpBB forums at htts in the Tiger Tech backups?
Separate names with a comma.