Automated backups


#1

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


#2

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


#3

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