Put it in a daily cronjob if you like, or extend it to copy the backup to another machine:
When looking at MySQL output, it is sometimes more convenient to split up the number of records returned into separate pages and include hyperlinks to further pages in the result set, a layout often referred to as pagination. The following is an...