Automated backups

Hi,
I’ve just signed-up with DH and would like to create an automated daily backup of my Mysql db that is saved to a designated folder. This folder would be visible to the public.

I have a feeling it probably could be accomplished with a cron job but I don’t know even where to begin.

Can somebody start me off?

TIA
planetphillip

Phillip
http://www.planetphillip.com/
Commentary and Analysis of Sci-Fi Single Player First Person Shooters

See This post from me earlier.

Uhm, and then read the MySQL documentation, perhaps the section about the mysqldump utility.
ie, your command might look like
mysqldump -u [username] -p [password] -h [hostname] -r [file] [database], eg
mysqldump -u shorty -p mafia -h mysql.example.com -r backup.sql phpbb_forum

:cool: Perl / MySQL / HTML+CSS

Ok,

I’ll check out the manual and see what I can get working. Thanks for the example.

Regards
Phillip

Phillip
http://www.planetphillip.com/
Commentary and Analysis of Sci-Fi Single Player First Person Shooters