mysql dump file and bash script.

[manata]

Hi every one,

I am new to shell scripting, and have a question regarding MySQL dumps.

I have a file (text) , MySQL dumps. I would like to write a bash script that will dynamically generate sql dumps for each database, and save the output to files named after the database.

Can anyone tell me how to start coding, and what I need to use, in order to accomplish this.

Thanks.

[eric85]

Hello,

Hope following script will help you to take backup

if [ -d /Backupfolderpath/`date +%a` ] ; then
/usr/bin/mysqldump \
--user=mysqluser \
--password=password \
--databases databasename database > \
/Backupfolderpath/`date +%a`/database.sql
else
echo "Target directory /Backupfolderpath/`date +%a` does not exist"
fi

PS:: linuxforums.org/forum/other-distributions/163328-command-problem.html