[VPM] backup MySQL database with perl

Matt Elrod matt at elrod.ca
Tue Mar 24 23:11:15 PDT 2009


I'd use mysqldump with cron to save a backup to disk.

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Databases can be big for attachments, but you can also call
gzip from cron, so it might work on small databases.

Matt

Jer A wrote:
> All,
> 
> I am learning MySQL. I can manually backup use PHPmyAdmin.
> 
> what is an easy way to backup a database with perl (DBI), 
> programmatically, without knowledge of it's structure/contents (eg. 
> tables/records etc).
> 
> I would like to create some sort of scheduler for this as well.
> also, I wondering if backing it up as an email attachment is a good 
> thing as well?



More information about the Victoria-pm mailing list