When i run this script the old files are replacing with the latest one, but i need it be created in new folder with current date and time stamp.

### MySQL Server Login Info ###
MUSER="user"
MPASS='#####'
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
BAK="/home/foldername
GZIP="$(which gzip)"
NOW=$(date +"%d-%m-%Y")



### TAKING DATABASE BACKUP ###
[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*

#DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')" #This line is to backup all databases.
DBS=("DBname") #To Backup only specified databases use this line.
for db in ${DBS[@]}
do

FILE=$BAK/$db.$NOW-$(date +"%T").gz ##NOTE: To save some disk space the sql dump files are compressed using gzip;
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE ## You can uncompress them using the command "gzip -d <FILENAME>"
done

till here i am getting back up correctly. i am confused here at . i need this DB to stored in filesystem in a specific folder /DBback . and i need script to place in crontab.
Please give me some solution.

Why don't you make a new subdir in the
BAK="/home/foldername

with date and time stamp ?

modify this:
[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*

because it's always using the same path BAK="/home/foldername and it removes it and creates again (as far as I understand your script.

You are posting only crippled script lines so post the whole script and use [code] wraps around it to make it readable for someone who will help you.

like

Actually this is completed code. next lines in this script are copying the Db's to FTP server
once gain i am sending the complete the script for reference.
### MySQL Server Login Info ###
MUSER="user"
MPASS='#####'
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
BAK="/home/foldername
GZIP="$(which gzip)"
NOW=$(date +"%d-%m-%Y")

### FTP SERVER Login info ###
FTPU="FTPuser"
FTPP="passwd"
FTPS="hostname"



### TAKING DATABASE BACKUP ###
[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*

#DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')" #This line is to backup all databases.
DBS=("DBname") #To Backup only specified databases use this line.
for db in ${DBS[@]}
do

FILE=$BAK/$db.$NOW-$(date +"%T").gz ##NOTE: To save some disk space the sql dump files are compressed using gzip;
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE ## You can uncompress them using the command "gzip -d <FILENAME>"
done


ncftp -u "$FTPU" -p "$FTPP" $FTPS<<EOF
mkdir $NOW
cd $NOW
lcd $BAK
mput *
quit
EOF


In this code . please guide in which line do i need to add the code to create the folder with time stamp.
I just need to take back up and save the files in same server not in the remote server.
Please give me some solution.

Hello

finally I found time to reply to you.

Replace with this instead of "[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* "

and you will have multiple files with date&time stamp in your "BAK="/home/foldername" directory
and don't forget to close " at BAK="/home/foldername" (<-- like this) as your code is missing closing quote "

If you don't want to FTP the files then comment out:

thanks Lithos

You're welcome. I hope it's what you wanted if it works for you.

yes working .

Can you use the Thread Tools to mark it SOLVED if so (read my signature)?

1 members found this post helpful.