I am trying to figure out what files to backup so that my catalog stays
intact in case my bacula server goes down. The catalog backup that is
setup by default tries to back up /var/bacula/working/bacula.sql - this
file/directory does NOT exist on my machine. The MySQL database is
located in /var/
Hello Bacula Users,
i have installed the bacula backup system with one server and some clients over
a network. All programms works great, but i have a small problem: the mysql
database is _really_ big. I have nearly 55 GB of backup files and the database
grow up to nearly 250 GB. Is that usual?
Quintin,
The file /var/bacula/working/bacula.sql is created 'on the fly' by the
RunBeforeJob script. It is deleted immediately after it is backed up by the
RunAfterJob script. That is why it appears that the file does not exist on your
system.
You'll want to copy the BSR file (or email it to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Quintin Giesbrecht wrote:
I am trying to figure out what files to backup so that my catalog stays
intact in case my bacula server goes down. The catalog backup that is
setup by default tries to back up /var/bacula/working/bacula.sql - this
file/directo
(yea, I know it's something of an old message...)
Quintin Giesbrecht wrote:
The MySQL database is located in /var/lib/mysql/bacula - I have
backed up this file, and moved it to a different machine that is
running bacula and have gotten it to work. That is, I can list files
from my backups, I get h
SNIP
> If my bacula server goes down, can I rebuild it, reinstall bacula,
> restore my /var/lib/mysql/bacula directory, and everything will work
> as it should?
No. You don't have any way to guarantee that the database isn't
corrupt.
SNIP
In Reply to: Phil Brutsche
SNIP
> If my bacula server goes down, can I rebuild it, reinstall bacula,
> restore my /var/lib/mysql/bacula directory, and everything will work
> as it should?
No. You don't have any way to guarantee that the database isn't
corrupt.
___
On Tue, 2005-04-12 at 09:24 -0500, Quintin Giesbrecht wrote:
> In Reply to: Phil Brutsche
>
> SNIP
>
> > If my bacula server goes down, can I rebuild it, reinstall bacula,
> > restore my /var/lib/mysql/bacula directory, and everything will work
> > as it should?
>
>
we backup about 500Gb +
with daily incrementals, weekly fulls and monthly fulls.
the database may need a bit of cleaning but it is currently at 7Gb ...
for performance reasons we'll be moving this over to a dedicated mysql
server... when you want to restore and mysql has to select in 7Gb it can
argh, i make a mistake, its not 250GB, its 250MB (MegaByte!!!)
sorry, but it is still to big ...
On Tue, 14 Jun 2005 16:41:00 +0200
Bernhard Suttner <[EMAIL PROTECTED]> wrote:
> Hello Bacula Users,
>
> i have installed the bacula backup system with one server and some clients
> over a network.
2005 10:16
> To: bacula-users@lists.sourceforge.net
> Subject: Re: [Bacula-users] mysql database problem
>
> argh, i make a mistake, its not 250GB, its 250MB
> (MegaByte!!!) sorry, but it is still to big ...
>
> On Tue, 14 Jun 2005 16:41:00 +0200
> Bernhard Suttner <[EM
Hello,
I'm using bacula 2.4.1 on ubuntu 8.04.
I'm doing backups of different clients, which are working.
But the backup of one client (my server: this is where director, fd, sd and
mysql are running), which is the largest amount of data to be saved, failes:
nas-fd JobId 1603: /music is a d
Table 'bacula.batch' is temporary.
MySQL man:
"A TEMPORARY table is visible only to the current connection, and is
dropped automatically when the connection is closed. This means that
two different connections can use the same temporary table name
without conflicting with each other or with an exis
13 matches
Mail list logo
