[SOLVED] How to backup a particular Database!! in MYSQL

anishkumarv · 06-27-2011, 09:28 AM

Hi All,

Thanks in Advance!!

How to backup a particular Databases..through Bash script!!

For example i have 6 databases;

Anish
linux
Software
Questions
Rhce
Google

these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
through script. Is it possible !!

TB0ne · 06-27-2011, 10:07 AM

Quote:

Originally Posted by anishkumarv

Hi All, Thanks in Advance!!

How to backup a particular Databases..through Bash script!!
For example i have 6 databases;

Anish
linux
Software
Questions
Rhce
Google

these are the databases i have from that i want to take "Anish" and "questions" database backup regularly. through script. Is it possible !!

Yes...did you try to look this up?? It's been covered many, MANY times, on this site, and Google has thousands of documents that tell you how.

Code:

mysqldump -u <user name> <database name> > /path/to/file.sql

You could have easily found this if you had bothered to look.

anishkumarv · 06-27-2011, 10:19 AM

I got What i expect!!

Code:

#!/bin/bash
date=`date +%Y-%m-%d_%H.%M.%S`
echo Backup Started $date  >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log
###########################################################
#create directory to store mysql database backup
mkdir /var/tmp/mysqldatabasebackup$date
if [ $? -ne 0 ]
then echo "Backup failed with errors" for $date >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log
exit
else
echo “directory mysqldatabasebackup$date created”  >> /var/tmp/mysqlbackuplog/mmysqldatabasebackup$date.log
fi

# Back up MySQL databases 2 database name in the anish.txt file
###########################################################

for db in $(cat /root/Desktop/anish.txt)
do
                mysqldump -u root -proot  $db >> /var/tmp/mysqldatabasebackup$date/$db.sql
       echo DUMPING DATABASE FOR CLIENT ""$db"" >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log
       echo backup copy of $db is moved to /var/tmp/mysqldatabasebackup$date    >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log
        cd  /var/tmp/mysqldatabasebackup$date
        a=`du -sh $db.sql | cut -f1`
        echo THE SIZE OF $db.sql FILE IS $a >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log
done
echo "Backup completed successfully $date" >> /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log

cat /var/tmp/mysqlbackuplog/mysqldatabasebackup$date.log | mail -s "mysqlbackuplog" 07anis@gmail.com

Actually i know the command and all!! dude..but quite confused how to backup the particular

Two databases alone in Regular basis..okay!! Thanks TB0ne..

TB0ne · 06-27-2011, 11:37 AM

Quote:

Originally Posted by anishkumarv

I got What i expect!!
Actually i know the command and all!!

Then why did you ask the question, if you knew the answer?

Quote:

dude..but quite confused how to backup the particular Two databases alone in Regular basis..okay!! Thanks TB0ne..

If you know how to back up ONE database, you know how to back up ANY databases. Seems like you've already got the script to do it. Does your script WORK, are you asking for help with it?? Not sure why you posed the question, since you said you already knew how to back up a database, and have a script that already seems to (at first glance), work for backing up multiples....

lithos · 06-27-2011, 01:00 PM

Hi,
checking your script briefly I can say that it doesn't work because of some errors when I tried it on my test server at home.
I'll try to make some corrections (sometimes later) if you want help with your script if it's not working (although marked Solved)?

sorry for 'breaking in' to solved thread.

anishkumarv · 06-27-2011, 04:57 PM

Hi TB0ne,

(if i wasted your time means...i apologize for that)

Actually my requirement is want to take 2 databases backup through script.. i don't know how to made

changes in my existing script(in my existing script it will take all the databases) ...

after posting this thread to here only one of my friend suggested using for loop we can easily solve

your requirement if you mention your (2 databases) alone in one file name means from that we can read

the db name and we can take easily backup

Quote:

# Back up MySQL databases 2 database name in the anish.txt file
###########################################################

for db in $(cat /root/Desktop/anish.txt)

now its working fine..so i marked this thread as solved..

but still i am not compromised with this method..is it possible to do with out mentioning

a db name in a file...??

lithos · 06-27-2011, 05:23 PM

you can define the database names in a variable in the script like:

Code:

# Back up MySQL databases 2 database name in the anish.txt file
###########################################################
DATABASES="my_first_database
my_2nd-database"

for db in $DATABASES

which would be quite appropriate for this.
DATABASES="1st_name <-- this is deliberately written this way separating the names
2nd_database" <--- as this way the "do" loop will execute as many times you write the names to the DATABASES (you can define 10 or whatever you like)

chrism01 · 06-27-2011, 05:52 PM

The default IFS http://bash.cyberciti.biz/guide/$IFS is <space><tab><newline>, so spaces would work instead of a newline there.

My test

Code:

test="astr bstr"

for str in $test
do
    echo $str
done

output

Code:

astr
bstr