Re: Databases

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

Re: Databases

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

Re: Databases

On Jan 5, 2018, at 2:22 PM, Chris Miller wrote: > 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

Re: Databases

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

Re: First run...

On Fri, Jan 05, 2018 at 11:23:49AM -0800, Chris Miller wrote: > Hi Jean-Louis, > > | runtapes 1 # number of tapes to be used in a single run of amdump > > | Because you tell it to use one tape. > As advertised, Amanda behaviors that I don't yet understand... > > So, I suspect that

Databases

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.

Re: First run...

You set runtapes to 1.  Therefore, Amanda is only allowed to use one tape for a backup, and your backup doesn't fit on one tape. On 2018-01-05 01:35 PM, Chris Miller wrote: > Hi Folks, > > I have followed these instructions >

Re: First run...

No manual just a wiki and FAQ. The best way to learn is read the section on basic configuration then the section "under the hood" which tells you what the config is doing. Many of your questions about how to do the things you want with Amanda seem to be under some misunderstanding on what

Re: First run...

Hi Jean-Louis, | runtapes 1# number of tapes to be used in a single run of amdump | Because you tell it to use one tape. As advertised, Amanda behaviors that I don't yet understand... So, I suspect that vtape behavior is a big piece of Amanda and from this low point on the

Re: Serious tape error

On Fri, Jan 05, 2018 at 08:54:36AM -0500, Jean-Louis Martineau wrote: > This is an issue in 3.4, 3.4.1 and 3.4.2 > > It is fixed in 3.4.3 Ahh yes, I do [now] recall that fix being reported. Thanks, I will look for an available update. > > Jean-Louis > jl -- Jon H. LaBadie

Re: First run...

On 05/01/18 01:35 PM, Chris Miller wrote: Now, I recognize that the simple answer is I have made my vtapes too small, but there is a larger confusion. Why didn't the backup use as many vtapes as necessary? Somewhere there must be a good discussion of how vtapes work and what Amanda does in

First run...

Hi Folks, I have followed these instructions (http://docs.huihoo.com/zmanda/amanda-community-setup-15-minutes-ver13.pdf), interpolating where necessary, and solved all the "computer" problems along the way. I am now into "Amanda" problems, meaning things I don't completely understand. (-:

Re: amanda tape algorithm

On 04/01/18 12:59 PM, Ned Danieley wrote: > > I'm using > > taperalgo largestfit > > which I assume means that amanda will write to tape the largest DLE > available. I have 'runtapes' set to 2, and occasionally I'll see amanda > move on to the second tape when the first tape is reporting around

Re: Serious tape error

This is an issue in 3.4, 3.4.1 and 3.4.2 It is fixed in 3.4.3 Jean-Louis On 04/01/18 06:37 PM, Jon LaBadie wrote: > On Thu, Jan 04, 2018 at 05:12:27PM -0500, Jon LaBadie wrote: >> I use vtapes of 100GB and runtapes == 3. Most days only >> one tape is used. About once every 2 or 3 weeks a