shell-DBA

Backup and Restore Data Base

For Backup All MySQL Data Base click here

Task:              Backup MySQL Data Base
FILE:              Backup_All_MySQL.sh
Description:      This script will create a backup of each table in every database  (one file per table), 
                compress it and upload it to a remote ftp
Requirement:      Create a new user only for backups, with following privileges: 
                SHOW DATABASES, SELECT, LOCK TABLES and RELOAD
Note:                  Create daily cronjobs in /etc/crontab to backup runs daily

For Backup PSQL Data Base click here

Task:              Backup PSQL Data Base
FILE:              Backup_PSQLL.sh
Description:      This script will create a backup of database, 
                compress it and upload it to a remote ftp
Requirement:      Create a new user only for backups, with following privileges: 
                SHOW DATABASES, SELECT, LOCK TABLES and RELOAD
Note:                  Create daily cronjobs in /etc/crontab to backup runs daily