LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-07-2004, 09:31 AM   #1
dominant
Member
 
Registered: Jan 2004
Posts: 409

Rep: Reputation: 30
Automating a full database backup


I have to automate a mysql database bakcup as below

/usr/bin/mysqldump -u root -p mypass mydatabase > /opt/mydatabase.sql


in a executable file.

When i install this job in the crontab nothing work.

Where is my fault?
 
Old 07-10-2004, 05:30 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,506

Rep: Reputation: 100Reputation: 100
Hi!

First, test if you can actually run ANY crontabs. Create something that will do something that you can note - i. e. create a crontab like

echo test >text.txt

in BASH and see if at the time you set in the crontab, this file gets created.

If it does not work, find out if you have cron running at all.

If it does work, you might have a permissions problem - if I remember correctly you need to be root to add and remove crontabs. Also take a look at /var/log/cron (at least on RedHat 9) and see if the entries there indicate something is happening, or if there are error messages - I think you might find what you need there. Then, remedy whatever is posted as an error in the cron logfile (or post it here again) and see if it helps.
 
Old 07-10-2004, 08:59 AM   #3
dominant
Member
 
Registered: Jan 2004
Posts: 409

Original Poster
Rep: Reputation: 30
I finally found what i wanted.
http://right-web.net/right-dev/rwscr...dump-1.0.6.zip

The prog above generates a dump from a database or databases.
Very handy, indeed!!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Full Backup With Cpio! grim2 Linux - General 6 02-09-2012 07:43 AM
Full system backup. Terroth Linux - Newbie 11 06-21-2005 01:52 AM
full System Backup czezz Linux - Software 10 05-08-2005 02:50 PM
mysqlcc not displaying full database list vharishankar Linux - General 3 11-19-2004 08:01 AM
Full Backup.... LinuxBie Linux - Newbie 3 01-02-2004 11:43 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:27 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration