Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

script for backup database

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting script for backup database
# 1  
Old 04-06-2012
script for backup database
Hello sir,
i have used this for taking the database backup
Code:
5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql.

but it creates a zero size database and in mail it gives error like command not found.
Please Help me
Last edited by methyl; 04-06-2012 at 11:50 AM.. Reason: please use code tags
# 2  
Old 04-06-2012
Hi,
Try to execute the command directly in shell to ensure that nothing is missing, and the path is correct
# 3  
Old 04-06-2012
hello sir,
thanks for the reply but i am new to this and have no idea how to run shell directly and i have run those things in cronjobs .Please help me
# 4  
Old 04-06-2012
Code:
5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql.

Threre are several problems with this crontab line.
1) The \ characters should be / characters. This is unix not MSDOS.
2) There is a trailing . character which is not required (delete it).
3) The cron will execute at 5 minutes past the hour every hour 7/24. Hope this is intentional? It will not execute at 05:00.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cold Backup of Oracle database.

Hi i need a command to cut the last column from the location in a file and want write a gzip command like cat a.txt /data01/oracle/oradata/vas/data/system01.dbf /data01/oracle/oradata/vas/data/sysaux01.dbf /data01/oracle/oradata/vas/data/undotbs01.dbf... (3 Replies)
Discussion started by: javeedkaleem
3 Replies

2. Shell Programming and Scripting

Problem with backup and copy a database

Hi, I have many servers distributed on my customer locations all servers has MYSQL database. I want to backup database for each server on server at my location using scheduler. So I create Shell script file to backup and copy the database file from customer server to my server as... (3 Replies)
Discussion started by: amsbas
3 Replies

3. Shell Programming and Scripting

Help with database backup script

Hi, i am very new with linux shell script. my colleague gave a portion of this script, it backups all of your database and there is a option that selects a database that u do not want to include in your backup. what i want is the other way around, i want to select the databases that i only want... (3 Replies)
Discussion started by: makoyski
3 Replies

4. Shell Programming and Scripting

Create database using Backup file

Hi, I have backup file of database in my server. I want to create a that database in the same Mysql Server. How can I do that? Please send the steps to create the database using backup file? Thanks a lot, (1 Reply)
Discussion started by: aish11
1 Replies

5. Shell Programming and Scripting

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.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

6. UNIX and Linux Applications

Problem with Database backup

Hi! This is my first post and im not that familiar with UNIX but I'll try to explain my problem.. I have a server here at work running Open UNIX Release 8.0.0 It has a special application on it that I'm trying to run a database backup on. For the last 2 weeks this has failed.. Usually the... (2 Replies)
Discussion started by: TaZ
2 Replies

7. Solaris

Veritas DataBase Backup

hi , we have a monthly policy for database backups . the database is a huge one about 200 GB in size and every month , we shut down the database and take a full system backup . my question is : Is there a way to know that i have taken a valid backup, I need to do something like a test restore... (5 Replies)
Discussion started by: ppass
5 Replies

8. UNIX for Dummies Questions & Answers

Backup of Product Database

HI, I know its scarey me asking this, but system is homegrown and I am just having fun, but at the same time dont want to have tooo much fun where the phrase "little knowledge is dangerous" perfectly fits my actions ;-). I have a couple of packages that are failing to be removed... #... (2 Replies)
Discussion started by: Student37
2 Replies

9. 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