Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 07-07-2004, 09:31 AM   #1
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
Senior Member
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,540

Rep: Reputation: 101Reputation: 101

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
Registered: Jan 2004
Posts: 409

Original Poster
Rep: Reputation: 30
I finally found what i wanted.

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


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 > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:45 PM.

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