Creating a CronJob

[keat63]

Guys.

It looks like something is a miss on our shared hosted server when running a manual DA full domain/ database backup, where as it's generating high loads.
Until our hosts have figured out what's wrong, they've suggested me creating a CronJob.
I can see the link to CronJob in DA, and i can easily create the schedule, but creating the job it's self, i havn't a clue.

I assume, i have to either create a file and drop the location to this file this in the command box, or dump the whole command in there.
Eitherway, it's nothing iv'e ever done before.

Could anyone point me in the right direction.
I did a search, but the results i got back didn't really help.

 

[SeLLeRoNe]

For dump a MySQL DB from command line you can use this:

/usr/bin/mysqldump -uDBUSERNAME -pDBPASSWORD -DDATABASENAME > /home/YOURUSER/mybackup.sql

-u -p and -D are non-spaced cause they must like this

Once cron runned, you'll find a backup in your user home directory (if everything went well at least).

Regards