Run a PHP5 cron job:
php /home/username/public_html/cron.php
Optional flags sometimes required for a PHP cron job:
php -q /home/username/public_html/cron.php
Run a PHP4 cron job:
/usr/local/php4/bin/php /home/strong>username/public_html/cron.php
Use a specific php.ini file:
php -c /home/username/public_html/php.ini /home/username/public_html/myscript.php
GET a remote file:
/usr/bin/GET http://www.example.com/file.php
Perl
Run a CGI cron job:
perl /home/username/public_html/cgi-bin/file.pl
SSH
Run a code script cron job:
/bin/sh /home/username/public_html/file.sh
MySQL
Note: It is a good practice to not type your password out in the follow commands but to simply use the -p flag alone and have the system prompt you for the password. This way your password stays secure and is never on the server as plain text.
Command to import a database:
mysql -u mysql_user -ppassword database_name < backup.sql
Command to export a database:
mysqldump -u mysql_user -ppassword database_name > backup.sql
Custom Installations without Easy Apache 3 (VPS/Dedicated)
PHP
Command to run for a PHP5 cron job:
/usr/local/php5/bin/php5 /home/username/public_html/cron.php
Command to run for a PHP4 cron job:
/usr/bin/php /home/username/public_html/cron.php