Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to backup a particular Database in MYSQL?
# 1  
Old 06-27-2011
How to backup a particular Database in MYSQL?
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  
Old 06-27-2011
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  
Old 06-27-2011
Hi friend,

Quote:
mysql -proot -Bse 'show databases
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  
Old 06-27-2011
Read and learn, maybe add a bit of cron.
# 5  
Old 06-27-2011
Hi pludi..

Thanks!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

File fetching from mysql database

I have a configuration file namely: abcd, that will be use for some service (like gammu) Inside that configuration file: number1 = 66673527 number1 = 8373272 How can I make the file to search the number1 and number2 from a mysql database? Any help will be very appreciated. Thanks (1 Reply)
Discussion started by: jazzyzha
1 Replies

2. UNIX for Dummies Questions & Answers

SSH import mysql database

Hi all, I am trying to import a database in putty with the syntax: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies

3. Programming

Help with mySQL database by perl script

Hello; I was trying to set up a mysql database using following script, but never went through. The code seems fine without any syntax error as I tested it: perl -c Brapa0101-db.pl Brapa0101-db.pl syntax OKHowever, whenever I run it, an error message was tossed out: DBD::mysql::st execute... (7 Replies)
Discussion started by: yifangt
7 Replies

4. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ... (2 Replies)
Discussion started by: SkySmart
2 Replies

5. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies

6. UNIX for Advanced & Expert Users

MYSQL command to take a backup of the database in Redhat linux 7.2

I am new to mysql database , we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup . what is the command for taking the entire database backup from the command prompt with all options. Thanks in advance Bache Gowda (4 Replies)
Discussion started by: bache_gowda
4 Replies
Login or Register to Ask a Question