There's a program called ZRM that does backups and restores of MySQL/Maria, but not PgSQL or PlSQL... It works brilliantly, and I've only ever had one complaint about it, and that's that despite being developed by the same folks as Amanda, it doesn't just work as a DLE in Amanda like it should to be a proper integrated point-in-time backup.
On Fri, Jan 5, 2018 at 1:01 PM, Debra S Baddorf <[email protected]> wrote: > Amanda just runs OS provided backup programs, such as DUMP and TAR. > Any other work your database needs must be done in advance, as you suggest > with your cron job suggestion. > Amanda won’t “prune” databases … but she’ll back up the file that’s on the > disk. > > Others: correct me if I’m wrong, of course. > Debra Baddorf > Fermilab > > > >> On Jan 5, 2018, at 2:22 PM, Chris Miller <[email protected]> wrote: >> >> Hi Folks, >> >> I can't find any explicit guidance for databases, so I assume that I do any >> database preparation in the cron job before I invoke amdump, and then tell >> Amanda to prune the database. Am I right? OR, is there an agent for the >> common databases, like MySQL, and PostgresSQL? >> -- >> Chris. >> >> V:916.974.0424 >> F:916.974.0428 > >
