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
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
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.
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
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?
>
>
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.
___
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
(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
-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
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
10 matches
Mail list logo
