Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
Cron error MySQL backup
View previous topic :: View next topic  
Author Message
vadim
Member


Joined: 16 Oct 2008
Posts: 40

PostPosted: Thu Jun 24, 2010 12:41 pm    Post subject: Cron error MySQL backup Reply with quote

It faild to make backup procedure for MySQL table. As the result we got the mistacke given below:

The same message appeared when we started the backup procedure on timetable.

Database backup failed : An error was detected in the new Cron configuration :


crontab 4.4
crontab file [-u user] replace crontab from file
crontab - [-u user] replace crontab from stdin
crontab -l [-u user] list crontab
crontab -e [-u user] edit crontab
crontab -d [-u user] delete crontab
crontab -c dir specify crontab directory

# If you don't want the output of a cron job mailed to you, you have to direct
# any output to /dev/null. We'll do this here since these jobs should run
# properly on a newly installed system, but if they don't the average newbie
# might get quite perplexed about getting strange mail every 5 minutes. :^)
#
# Run the hourly, daily, weekly, and monthly cron jobs.
# Jobs that need different timing may be entered into the crontab as before,
# but most really don't need greater granularity than this. If the exact
# times of the hourly, daily, weekly, and monthly cron jobs do not suit your
# needs, feel free to adjust them.
#
# Run hourly cron jobs at 47 minutes after the hour:
47 * * * * /usr/bin/run-parts /etc/cron.hourly 1> /dev/null
#
# Run daily cron jobs at 4:40 every day:
40 4 * * * /usr/bin/run-parts /etc/cron.daily 1> /dev/null
#
# Run weekly cron jobs at 4:30 on the first day of the week:
30 4 * * 0 /usr/bin/run-parts /etc/cron.weekly 1> /dev/null
#
# Run monthly cron jobs at 4:20 on the first day of the month:
20 4 1 * * /usr/bin/run-parts /etc/cron.monthly 1> /dev/null
31 7 * * * /etc/webmin/cron/tempdelete.pl
0 0 * * * /etc/webmin/mysql/backup.pl --all
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1753
Location: Greece

PostPosted: Thu Jun 24, 2010 3:48 pm    Post subject: Reply with quote

I believe you are referring to setting a cronjob through webmin, which has a bug.
You need to alter module config and remove USER.
Use 'crontab -e" or alternative edit /var/spool/cron/crontabs/$USER .
and add "0 0 * * * /etc/webmin/mysql/backup.pl --all" or any other commend.
You can alternative use a script placed in /etc/cron.daily /etc/cron.hourly.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional