[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