Help in backing up my databse using cron job

[WSS1428]

Hello;

I need a help where I can backup my SQL database daily at 3 o'clock in the morning using the corn job commands in my site cpanel.

I am very new to this and never tried it before. I really appreciate any help in details as much as possible.

Thank you


WS

[peacemaker]

login to cpanel ...

in advanced options...you can find cronjob....go there ....go to standerd cron manager

set the time to 3 (synchronize it with ur system time)

the command to run
: mysqldump <databsename> > <databasename>.sql
eg : mysqldump anj_db > anj_db.sql

hope it helped you

[WSS1428]

Thanks for your help, can you also tell me how to backup the same database but on a remte server. I appreciate giving me the full command.

example: I need to copy db.sql to www.remoteserver.com/backup

Thanks alot