BackupPC is a high-performance, enterprise-grade system for backing up Linux, WinXX and MacOSX PCs and laptops to a server’s disk. BackupPC is highly configurable and easy to install and maintain.
The first thing to do is to install the CentOS testing repo, along with the yum-priorities plugin.
# cd /etc/yum.repos.d
# wget http://dev.centos.org/centos/5/CentOS-Testing.repo
# yum install yum-priorities
If you have RPMForge’s repo installed, you’ll want to make sure all the CentOS Base items are priority 1, RPMForge’s items priority 2, and CentOS testing repo is priority 3.
Install BackupPC
Next, install the BackupPC RPM, Apache, and mod_perl. All the Perl dependencies will be collected automatically.
# yum –enablerepo=c5-testing install backuppc httpd mod_perl
mysqldump - a database backup program
The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server).
If you are doing a backup on the server and your tables all are MyISAM tables, consider using the mysqlhotcopy instead because it can accomplish faster backups and faster restores. See mysqlhotcopy(1).
There are three general ways to invoke mysqldump:
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] –all-databases
If you do not name any tables following db_name or if you use the –databases or –all-databases option, entire databases are dumped.
To upload a backup file to backup repository:
Go to Domains > domain name > Backup Manager (in the Files group) > Database Backup Repository and click Upload Backup File.
Select the database in which repository you want to upload the backup file to in the Database name menu.
Click Browse… and select the required backup file.
Leave the Restore database backup immediately upon uploading check box selected if you want the database contents to be restored immediately after the backup file is uploaded.
Click OK.
The database backup file will be uploaded to the backup repository of the specified database.
Resource : http://parallels.com/Plesk/
Downloading Backup Files from Plesk Server
To download a backup file from a backup repository within the control panel
Access the repository you need.
To access your own repository of backup files, go to Home > Backup Manager (in the Server group).
To access a repository of a reseller or client, go to Resellers > reseller’s name > Backup Manager (in the Files group) or Clients > client’s name > Backup Manager (in the Files group).
To access a repository related to a specific Web site, go to Domains > domain name > Backup Manager (in the Files group).
Click the icon corresponding to the backup file you wish to download.
Select the location where you wish to save the backup file and click Save.
The backup file will be downloaded from the backup repository.
Configuring Global Backup Settings in Plesk
If you serve numerous Web sites, you may want to configure the backing up process so that it does not consume much server resources.
To reduce the server load and set the disk space usage policy:
1. Go to Home > Server group title menu > Backup Settings.
2. Specify the number of simultaneous backup processes in the Maximum number of simultaneously running scheduled backup processes box. The default value is 10. Type a lesser value.
3. Select the Run scheduled backup processes with low priority check box.
4. Select the Do not compress backup files check box to disable compression.
5. Click OK.
6. To prevent the backing up processes from consuming all available disk space on the server, do the following:
1. Access the server’s file system, locate and open the file [Parallels Plesk Panel installation directory]/admin/share/pmmcli/pmmcli-rc with a text editor.
2. Locate in this file the line FREE_DISK_SPACE 20, and in place of 20, specify the amount of free disk space in megabytes that must be reserved.
3. Save the file.
Doc Source: parallels.com/Plesk/