Automatic Database backups using free Sypex Dumper tool

Automatic database backups can be set up very easily using a simple shell script and a cron job. However it may not be a practical solution for huge databases and the restoration process can also be difficult. There are various tools available to make this process simple. Sypex Dumper is just one of them. What is Sypex Dumper Sypex Dumper is a software product (PHP-script), which can help you create a backup copy (dump, export) of a MySQL database, and also restore the database from the backup file if needed. Read more and download With this tool huge databases can be backed up and restored with very high speed using least server resources and greatly reducing the size of the database dumps. Free version of the tool is enough to create the automatic backups. The Paid version allows to selectively restore a particular table from the entire database. Steps to set up automatic Database Backups Let's assume you want to create backup of your database every day and keep the...
Read More

Shell script to backup database and send it to remote server automatically

This article explains how to create a database backup script to send the backup to remote server  without any manual intervention. For security reasons or to enable disaster recovery it is important to keep database backup copies on some additional server outside your network. The process to create a script for database backup and to autosend it to a remote server is not really so complicated as many would think. To make it simpler let's divide the whole task in 3 different sub tasks Create a backup file of your database. Authorize the origin server i.e. Your current server to send the files to the remote server (So that the remove server knows that it is receiving the files from a genuine source) Create a script to simply SCP the files from the origin server to the remove server Above mentioned are mandatory steps. Additionally you may also want to create a log file to log the status of every step just in...
Read More