Welcome! » Log In » Create A New Profile

Databases

Posted by Chris Miller 
Chris Miller
Databases
January 05, 2018 12:59PM
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
This message was imported via the External PhorumMail Module
Winston Sorfleet
Re: Databases
January 05, 2018 02:59PM
Databases are a bit of an odd animal when it comes to backups.  If a
single entry in a table changes, to the outside world, it appears that
the entire database (as a file) needs to be backed up.  That's why most
real databases come with their own backup mechanisms (often transaction
logs).

That being said, I use (for mysql) mysqldump from a daily cronjob,
putting it into a file that amanda picks up.  I.e. I am not doing it
like a pro, but my databases are quite small.

On 2018-01-05 03:22 PM, Chris Miller 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
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login