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

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

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!!

      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