Lloyd
01-02-2008, 03:54 PM
Mysql is the world's most popular database for Internet use, powering applications on thousands of websites. It's used in most blogs (such as Wordpress), most CMS's (such as Joomla and Drupal), and most forums (such as phpBB). It's very likely that you use one or more Mysql databases on your Rimuhosting server.
Mysql databases need to be backed-up, and backup should usually be done more than once per day. Rimuhosting backs up your server once per week. Obviously, if you use mysql databases for frequently-updated data, you *must* have a backup and recovery strategy. (A RAID sometimes fails!)
This article (with backup script) shows you how to easily set up full and incremental compressed backups of multiple databases to Rimuhosting's backup server using mysqldump and mysql binary log files. Backup will be done every 6 hours (configurable), with a full backup once per week. Since backups are incremental and are compressed, the amount of data to be transmitted is relatively small. It is assumed you have a running mysql server, which should provide you also with the utility programs needed for both backup and recovery. This backup method should work for any mysql database storage engine (e.g., myisam and innodb). It is however tested only for myisam databases on Debian Etch. read full article (http://seedsofthought.net/mysql-backup)
Mysql databases need to be backed-up, and backup should usually be done more than once per day. Rimuhosting backs up your server once per week. Obviously, if you use mysql databases for frequently-updated data, you *must* have a backup and recovery strategy. (A RAID sometimes fails!)
This article (with backup script) shows you how to easily set up full and incremental compressed backups of multiple databases to Rimuhosting's backup server using mysqldump and mysql binary log files. Backup will be done every 6 hours (configurable), with a full backup once per week. Since backups are incremental and are compressed, the amount of data to be transmitted is relatively small. It is assumed you have a running mysql server, which should provide you also with the utility programs needed for both backup and recovery. This backup method should work for any mysql database storage engine (e.g., myisam and innodb). It is however tested only for myisam databases on Debian Etch. read full article (http://seedsofthought.net/mysql-backup)