How to backup a particular Database in MYSQL?

Shell Programming and Scripting
1

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 !!

With Regards
Anish Kumar.V

2

Where are the databases located?
How are you accessing the databases?

To do this thru a unix script, would need to know the complete path to the databases. For example...

/work/data/access/Anish

3

Hi friend,

Using this command i can get the all the databases list from that i want

to take particular 2 databases..

Why we need the exact path and all...??

If i get the exact 2 databases means we can easily take the backup

using mysqldump command..

4

Read and learn, maybe add a bit of man cron (POSIX).

5

Hi pludi..

Thanks!!!