Need Help with creating a Cron Job


 
Thread Tools Search this Thread
Operating Systems Linux Need Help with creating a Cron Job
# 1  
Old 03-01-2008
Need Help with creating a Cron Job

Hello Guys.

I really need some help creating a cron job.

I want to back up my mySQL database, which runs a phpBB Forum.

I need the backup to run every 6 hours - but the host can make it run every 6 hours.

I need it to backup to a directory called Backups (on the root) and i dont want it to overwrite the last backup - so if they could be called backup(date/Time), backup(date/Time) that would be great.

Can anyone help me - i know basic MYSQL etc, but not too good with it, so I would really appreciate the help.

Cheers
# 2  
Old 03-03-2008
Sounds like you actually need a custom shell script written to do this and then create the cron in your crontab. This is how I would do it since you can create settings and such to set your backup locations etc. I have written a shell script that does just this.

If you want the source, just PM me and I'll let ya have at it.

Regards,
Drew
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cron job - Need to run Cron every quarter at particular time

Hi, 1) If some job supposed to run on 1st of every month at 7 AM In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day? 2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct) And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies

2. Shell Programming and Scripting

Commented cron job -- cron monitoring

Hi I have a requirement to write a shell script,that will check the all commented job in cron job.Please help !! (2 Replies)
Discussion started by: netdbaind
2 Replies

3. Solaris

Cron job running even after cron is removed

Hi , I have removed a cron for particular user , but cron job seems to be running even after the cron entry is removed. The purpose of the cron was to sendmail to user ( it uses mailx utility ) I have restarted cron and sendmail service still user is getting mail alerts from the cron job. And... (4 Replies)
Discussion started by: chidori
4 Replies

4. UNIX for Dummies Questions & Answers

Help Creating Daily Cron Job

I need to create a cron job that will run daily to change permissions to a particular folder to 666 every 24hrs. I have no experience with crontab or cron jobs at all so if someone can guide me through this it would be a great help. The folder's example is 'www/test/htdocs' Also if you... (3 Replies)
Discussion started by: Xechno
3 Replies

5. Solaris

cron job starts new cron proccess

I run cron in solaris 10 zone. One cron job which syncing files to nfs mounted on container, creates after finishing another cron proccess(/usr/sbin/cron), and after 100 existing cron proccesses next cron job will not start. It's too weird for me, I'm not able to solve this problem. Theoretically... (3 Replies)
Discussion started by: ron76
3 Replies

6. UNIX for Dummies Questions & Answers

CRON usage for CRON job

can anybody explain the usage of CRON for adding a cron job. please provide an example also for better understanding !!! Thanks (1 Reply)
Discussion started by: skyineyes
1 Replies

7. UNIX for Dummies Questions & Answers

Cron JOB

I have a cron job that ran for 3 months; all the suden, it stops working. There were no changes in the script. Is there away that I can find out why? can someone with root permission disable my cron-job? Is there away that I can look into the system to see who may have done that? My cron job... (1 Reply)
Discussion started by: bobo
1 Replies

8. UNIX for Dummies Questions & Answers

Cron job

Regarding Cron job, i want to execute a scriptevery 4 days once irrespective of a week or a month. Is it possible?Any help (2 Replies)
Discussion started by: santho
2 Replies

9. Shell Programming and Scripting

Cron job

Hi All , We have few scripts which uses common environment/path setting variables. Now instead of putting classpath , framework,java_home ..... etc. in all the script, can we make a file with all common settings which can be envoked by the scripts while running. If yes , say setting file is... (3 Replies)
Discussion started by: pankajkrmishra
3 Replies

10. Shell Programming and Scripting

Cron job

Hi All I am trying to run a .sh file from cron but its not performing its intended purpose, though the same sh file works fine when triggered manually.Following mail I recieve when it tries to run the script. ********************************************************* To: wlsdev05 Subject:... (16 Replies)
Discussion started by: pankajkrmishra
16 Replies
Login or Register to Ask a Question