Backing up a database using mysqldump

#! /bin/sh
Day_str= ' Date +%j '
day= ' Date +%y%m%d '
Days_str= ' echo ' $day _str% "|BC"
Cd/home/db_backup
Echo ${day}
Mysqldump--opt-hhostip-uusername-ppassword--databases dbname1 dbname2 > ${day}.sql
Gzip-f ${day}.sql
#
#backup binary file
Mysqladmin-hhostip-uusername-ppassword Flush-logs
cp/var/lib/mysql/mysql-bin*.
Gzip-f mysql-bin*

If there is no BC or mysqladmin on your computer, you will need to install yum-y installed mysql BC

Backing up a database using mysqldump