Ultimate MYSQL backup script - part one
 

As promised, I've now put up part one of the mysql backup script I mentioned a few weeks ago. You can find it by going to:

Ultimate MYSQL backup script

The end product pretty much does this (an example of the report you are sent):

Quote:
Starting at 02:39:01
......
...
.
Closing down site-name
......
...
.
Sleeping 10 seconds to let connections die
......
...
.
Starting MYSQL dump
......
...
.
MYSQL dump end. Starting file compression
......
...
.
File compress end. Opening up site-name
......
...
.
Starting SCP backup transfer to destination
......
...
.
SCP transfer end
......
...
.
Ending at: 02:39:26
(If there are any errors reported please investigate)
.
.....
..............
Detailed Information
..........
......
.
Dump took: 0 hours 0 minutes 5 seconds
Compression took: 0 hours 0 minutes 8 seconds
Transfer to destination took: 0 hours 0 minutes 2 seconds
Site was down for: 0 hours 0 minutes 23 seconds
Time it took to execute this whole script: 0 hours 0 minutes 25 seconds
Posting this in a new thread in case George wants to add a link to it to one of his stickied threads - as I think it will come in handy for a lot of people.

In part two we'll use rsync to keep our files/uploads backed up too - so stay tuned!

Apologies for the blog being a bit bare - rushed to get it up as I know a few people have been waiting for the guide.