Require a way to backup a mysql db

ramjamman has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks
I am looking for a way to backup a MySQL database that can be executed from a perl script.
I have looked on CPAN but the modules I could find seem to still be in development.
Does anyone know of a working module or have any suggestions on how to accomplish this please.
It needs to be accomplished by a user clicking a simple link and the resulting output file written to a directory on the server.

I apologise if I might of missed the obvious in advance

Comment on Require a way to backup a mysql db

Replies are listed 'Best First'.
Re: Require a way to backup a mysql db by NetWallah (Canon) on Oct 23, 2014 at 00:04 UTC
How about this old node ? "You're only given one little spark of madness. You mustn't lose it." - Robin Williams	[reply]
Re: Require a way to backup a mysql db by ramjamman (Sexton) on Oct 23, 2014 at 09:30 UTC
Thank you so much exactly what I was looking for NetWallah And thank you for showing me a part of the Monastery I had missed so far!!	[reply]
Re^2: Require a way to backup a mysql db by NetWallah (Canon) on Oct 23, 2014 at 17:26 UTC
You are welcome. For a more robust backup solution, you can steal code from webmin - their mysql backup routines are implemented in perl, and run via the command line. Webmin also has a web GUI for configuring scheduled mysql backups as well as on-demand. Included are fun features like e-mail notification ! "You're only given one little spark of madness. You mustn't lose it." - Robin Williams	[reply]