simple cron job

[bzgzd]

Hello.

I would like to create one cron job on my addon domain web site.
In CPanel there is this warning:

Warning: You need to have a good knowledge of Linux commands before you can use cron jobs effectively. Check your script with your hosting administrator before adding a cron job.

But my knowledge of Linux commands is zero...

On page that I am creating (http://www.puzzleslogic.com) I need to automatically remove every day (once per day) from one mysql table all entries that have specified date older then 30 days.

Best solution for me would be if I can create cron job that will "execute" my php script.
Is this possible?

[rec9140]

Originally Posted by bzgzd

Hello.

I would like to create one cron job on my addon domain web site.
In CPanel there is this warning:

Warning: You need to have a good knowledge of Linux commands before you can use cron jobs effectively. Check your script with your hosting administrator before adding a cron job.

But my knowledge of Linux commands is zero...

On page that I am creating (http://www.puzzleslogic.com) I need to automatically remove every day (once per day) from one mysql table all entries that have specified date older then 30 days.

Best solution for me would be if I can create cron job that will "execute" my php script.
Is this possible?

use, ALL ONE LINE! :

cd /home/<YOURUSERNAME>/public_html/YOURDIR; php -q YOURSCRIPT.php

Put this to run at what ever time you want it to.

To understand the settings:

http://www.reallylinux.com/docs/basiccron.shtml

Use the menus in CPanel to select the once/per day option and then tell it at what time to do it.

They unfortunately removed the more Unix like interface, so you will have to SSH in to use crontab -l and crontab -e to setup that way.

[Pitrow]

Originally Posted by rec9140

They unfortunately removed the more Unix like interface, so you will have to SSH in to use crontab -l and crontab -e to setup that way.

I'm pretty sure since he said his knowledge of linux commands is zero, he's not going to have a clue what any of that sentence means.

[bzgzd]

Originally Posted by rec9140

cd /home/<YOURUSERNAME>/public_html/YOURDIR; php -q YOURSCRIPT.php

They unfortunately removed the more Unix like interface, so you will have to SSH in to use crontab -l and crontab -e to setup that way.

Thx. That looks good... I think I will try it just by using "php -q </home/full path to script>.php" as my script will modify only mysql table and so I think i don't need to "cd" to script directory.

If I understand it correctly your last sentence about SSH and crontab is related to setting when to run that cron-job so for me no need to understand it as it can be set from CPanel with that web form.