How to save and run a cron job from a file?

[Website]

The panel i use for my hostign doesnt allow me to put the full cron job command there but instead they want me to point a file to run.

I want to run below command from a file. How can i do it?

mysqldump --opt -Q -u USERNAME --password=PASSWORD DBNAME | gzip > /public_html/Daily/ukdb.gz

[sureshk]

this may help try this :

# install CRONTAB if crontab is writable
CRONTAB="/etc/crontab"
[ -w \$CRONTAB ] || exit

grep -q "program" \$CRONTAB ||
echo "# About the Program
# this cron job is for 5 minutes
*/5 * * * * root /file/path/file.sh  
" >> \$CRONTAB && killall -1 cron crond 2>/dev/null
echo "Modified /etc/crontab"

	};
	# Bye
	exit(0);
}

[Website]

this may help try this :

# install CRONTAB if crontab is writable
CRONTAB="/etc/crontab"
[ -w \$CRONTAB ] || exit

grep -q "program" \$CRONTAB ||
echo "# About the Program
# this cron job is for 5 minutes
*/5 * * * * root /file/path/file.sh  
" >> \$CRONTAB && killall -1 cron crond 2>/dev/null
echo "Modified /etc/crontab"

	};
	# Bye
	exit(0);
}

I didnt understand anything from this.
Should i create a file with these codes?
What should i format that file as?
Where is the path to put the backup file?

Oh maybe you got confused and think i have a VPS and console. Ummm, no. I have a shared hosting with no support

[atreyu]

The panel i use for my hostign doesnt allow me to put the full cron job command there but instead they want me to point a file to run.

I want to run below command from a file. How can i do it?

mysqldump --opt -Q -u USERNAME --password=PASSWORD DBNAME | gzip > /public_html/Daily/ukdb.gz

So how it works is you just give them a script and tell them you want it to be a cron, and when to run, and they take it and cron it for you?

or do you actually supply them a cron-formatted job file, complete with the date/time notation of when to run?

If the first scenario, just create a file, call it "cron-script.sh", and in it put:

#!/bin/bash
mysqldump --opt -Q -u USERNAME --password=PASSWORD DBNAME | gzip > /public_html/Daily/ukdb.gz

then make the script executable:

chmod +x cron-script.sh

you can run it, to make sure it works:

./cron-script.sh

then fork it over to the hosting admins...

[Website]

I get "No Support" from hosting company because its free hosting.
I tried the cron-script.sh solution but nothing happened.

You can check out the panel and the services in 1freehosting.com
There is a cronjob option but you need to give the file path for it.

[atreyu]

i visited the site but did not see a way to view the cron function (w/o signing up). does the website give you any instructions about using the cronjob? How do you know it is not working? Do you get real-time feedback or a log or what?

[Website]

i visited the site but did not see a way to view the cron function (w/o signing up). does the website give you any instructions about using the cronjob? How do you know it is not working? Do you get real-time feedback or a log or what?

Well i assume if its there, its working. Why would they put it there if its not working. Attached is the ss

[atreyu]

ah, so it looks like it is expecting to run a php script (i think), based upon that top line in your ss:

Command to run:  php -f /home/blah/[                        ]

can you confirm that?

anyway "php -f" means pass a file to php to parse it (and suppress HTTP header output).

[atreyu]

so if that's the case, you could make a PHP script, called "mysql-cron.php" and in it put:

 <?php
system('mysqldump --opt -Q -u USERNAME --password=PASSWORD DBNAME | gzip > /public_html/Daily/ukdb.gz');
?>  

[Website]

so if that's the case, you could make a PHP script, called "mysql-cron.php" and in it put:

 <?php
system('mysqldump --opt -Q -u USERNAME --password=PASSWORD DBNAME | gzip > /public_html/Daily/ukdb.gz');
?>  

Good idea. Trying. Will let you know