First Note Down the server and database information for which server and which database do you want to schecdule backup(crontab) jobs. For example i’m taking following servers and databases for scheduling backup jobs. SERVER IP DATABASE 10.10.10.1 …
In this shell script will help you to take the backup of PostgreSQL table definition with different or individual file name as schema based. # Config: DB=”DBA” U=enterprisedb export PGPASSWORD=”tcs45″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t …
Currently we want to take the backup what are the schema name having kafi and nijam. PreRequest: checking table rows count of particular table. Check the schema’s size. check the available backup location size. 1.List the schema whoose name start …
Try following script , This script will take mysql database backup automatically and remove the old backup file which is over 3 days and once backup is completed means it will send mail confirmation If you know the mysql root password you …
Login with Google