simple automated backup of apache (your websites)

[anyweb]

ok i'm still playing with this and now i want to backup the mysql database weekly also, the exact same way as i am doing with apache.

 

the command to backup the database is executed from

 

/usr/local/mysql/bin

 

and it's

 

Code:

./mysqldump -u USER -p DATA >> forums_export.sql

 

i then have to input the root password

 

so, how can i automate this ? any ideas :)

 

cheers

 

anyweb