Topic: backup of the SME MySQL database

[cactus]

I sure can't figure out why the dump files didn't get loaded the first time we did the disaster recovery restore unless it had something to do with using the web panel for the restore or else the fact that we were restoring files from a 7.4 server onto a 7.3 server.

You should find clues on that in /var/log/messages of the affected services around the time you tried the restore. My guess is that the /var/lib/mysql/ you restored was corrupt, for reasons explained earlier, and restoring the dump script did not work. But you need the log file as that will really tell you why.

[wdepot]

We didn't add var/lib/mysql to the list of backups until after the server problem. When the disaster restore didn't restore the MySQL databases we thought that was the problem until it was explained earlier how DAR2 backed up these files. We have, of course, deleted the var/lib/mysql folder from our backup lists now that we know how the backup of the MySQL databases actually works by dumping the databases to a folder that is already in the backup list. The log files don't appear to have been transferred when we moved back to the original server computer so I'm not going to worry about finding the cause of the original failure to restore the databases now.