Re: [Bacula-users] Big problems with my Bacula.....

2005-09-07 Thread Kern Sibbald
On Wednesday 07 September 2005 12:56, Philipp Steinkrueger wrote: > Hi Kern, > > >Perhaps it didn't drop the database but it did drop each table -- > > otherwise, how can the example from the Catalog Maintenance chapter of > > the manual work? > > > >mysqldump -f --opt bacula > bacula.sql > >mysql

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-07 Thread Arthur Emerson III
Philipp Steinkrueger <[EMAIL PROTECTED]> wrote: > > if you dump the database and reload it into the server, > there are chances that the autoincrement values are renumberd. > i cant find a reference for that at mysql.com at the moment, > but i am pretty sure i've read something like this and the p

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-07 Thread preissler thomas
Hello, Am 07.09.2005 schrieb Philipp Steinkrueger: > Hi Kern, > > > >Perhaps it didn't drop the database but it did drop each table -- > >otherwise, how can the example from the Catalog Maintenance chapter of the > >manual work? > > > >mysqldump -f --opt bacula > bacula.sql > >mysql bacula < b

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-07 Thread Philipp Steinkrueger
Hi Kern, Perhaps it didn't drop the database but it did drop each table -- otherwise, how can the example from the Catalog Maintenance chapter of the manual work? mysqldump -f --opt bacula > bacula.sql mysql bacula < bacula.sql rm -f bacula.sql because of the --opt parameter in the mysqld

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread Kern Sibbald
On Tuesday 06 September 2005 17:26, Philipp Steinkrueger wrote: > Hi, > > Kern wrote: > > Hmmm. It looks like MySQL may have changed the behavior of their > > dump/restore, > > > which used to delete everything before doing a restore. If you did not > > explicitly delete your database before doi

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread Philipp Steinkrueger
Hi, Kern wrote: > Hmmm. It looks like MySQL may have changed the behavior of their dump/restore, > which used to delete everything before doing a restore. If you did not > explicitly delete your database before doing the restore, you probably > unknowingly duplicated all the records -- not ve

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread Phil Stracchino
Kern Sibbald wrote: > On Tuesday 06 September 2005 08:49, Masopust Christian wrote: >>Hello all, >>Bacula run fine till last weekend. Since Sunday every job fails with >>messages that entries to database ("INSERT INTO FILE (..") could not be >>made because of "Duplicate entries" >> >>First

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread Kern Sibbald
On Tuesday 06 September 2005 08:49, Masopust Christian wrote: > Hello all, > > my configuration is as follows: > > - Director and Storage at FedoraCore 3 system, Database Mysql 4.1.12, >Backup to Disk (2 RAIDs with 2.6TB) > - Clients are Linux, SUNs, Windows > > Bacula run fine till last week

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread preissler thomas
Hello, Am 06.09.2005 schrieb Arno Lehmann: > Hi, > > Masopust Christian wrote: > > >Hello all, > > > >my configuration is as follows: > > > > - Director and Storage at FedoraCore 3 system, Database Mysql 4.1.12, > > Backup to Disk (2 RAIDs with 2.6TB) > > - Clients are Linux, SUNs, Windows > >

Re: [Bacula-users] Big problems with my Bacula.....

2005-09-06 Thread Arno Lehmann
Hi, Masopust Christian wrote: Hello all, my configuration is as follows: - Director and Storage at FedoraCore 3 system, Database Mysql 4.1.12, Backup to Disk (2 RAIDs with 2.6TB) - Clients are Linux, SUNs, Windows Bacula run fine till last weekend. Since Sunday every job fails with mess