Re: [Bacula-users] What happen if I delete a single incremental between the full and another incremental

2010-10-18 Thread Graham Keeling
On Sat, Oct 16, 2010 at 09:33:13AM +0200, Hugo Letemplier wrote: Hi thanks a lot for your answers I have retried with a new test scenario its clear now and deleting an incremental is really dangerous. But I think that a function that enable the administrator to join 2 jobs would be cool.

[Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-18 Thread Robert Oschwald
Hi folks, I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, and then migrated to PostgreSQL 8.2 using dump/restore. Speed is dramatically better than with MySQL (I will post my postgresql settings if one is interested). Now when I use BAT to simulate a restore to recent, I

[Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Holikar, Sachin (ext)
Hello, We have a Bacula Version: 2.2.7 installed on SuSE 9 Linux. The database is mysql Ver 14.7. Bacula has been running since couple of years now. We noticed that the mysql partition where Write Bootstrap files (*.bsr) are stored is increased alot. Particularly bacula.sql file is grown to

Re: [Bacula-users] What happen if I delete a single incremental between the full and another incremental

2010-10-18 Thread Gavin McCullagh
On Mon, 18 Oct 2010, Graham Keeling wrote: On Sat, Oct 16, 2010 at 09:33:13AM +0200, Hugo Letemplier wrote: Hi thanks a lot for your answers I have retried with a new test scenario its clear now and deleting an incremental is really dangerous. But I think that a function that enable

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Damian Ge ; bicki
Holikar, Sachin (ext) wrote: Hello, We have a Bacula Version: 2.2.7 installed on SuSE 9 Linux. The database is mysql Ver 14.7. Bacula has been running since couple of years now. We noticed that the mysql partition where Write Bootstrap files (*.bsr) are stored is increased alot.

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Holikar, Sachin (ext)
Hello, I agree if I rename just the file name in bacula-dir.conf , it will start to write in a new file. But the point is the file which has grown in size is bacula.sql. So this is the actual file in question. Can we do something about this file? Thanx, Admin -Original Message- From:

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Damian Ge ; bicki
Holikar, Sachin (ext) wrote: Hello, I agree if I rename just the file name in bacula-dir.conf , it will start to write in a new file. But the point is the file which has grown in size is bacula.sql. So this is the actual file in question. Can we do something about this file? I

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Alan Brown
Damian Ge;bicki wrote: The bacula.sql, if I good remember, it's your main CatalgoDB - sqlite. The original poster is using mysql, not sqlite. bacula.sql is his database dump - it's a plain ascii text file. It can be compressed with gzip, bzip2, etc etc and you should keep multiple copies

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Bruno Friedmann
On 10/18/2010 11:06 AM, Holikar, Sachin (ext) wrote: Hello, We have a Bacula Version: 2.2.7 installed on SuSE 9 Linux. The database is mysql Ver 14.7. Bacula has been running since couple of years now. We noticed that the mysql partition where Write Bootstrap files (*.bsr) are stored

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Holikar, Sachin (ext)
You are right Alan. It's a database dump file. So you mean to say that I can compress the current file and rename it. So that next time Mysql will start writing onto new bacula.sql file? Will it not affect the functionality of mysql and in turn bacula any way? More importantly ,we wish to

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-18 Thread Rory Campbell-Lange
On 18/10/10, Robert Oschwald (r...@symentis.com) wrote: I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, and then migrated to PostgreSQL 8.2 using dump/restore. Speed is dramatically better than with MySQL (I will post my postgresql settings if one is interested). Now

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Damian Ge ; bicki
Alan Brown wrote: Damian Ge;bicki wrote: The bacula.sql, if I good remember, it's your main CatalgoDB - sqlite. The original poster is using mysql, not sqlite. bacula.sql is his database dump - it's a plain ascii text file. It can be compressed with gzip, bzip2, etc etc and you should

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Holikar, Sachin (ext)
Hi Bruno, You hit the bullz eye!! I read both the scripts make_catalog_backup delete_catalog_backup. Found that previous admin has modified this script. After the statement , mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 He is copying the bacula.sql file onto the location

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Phil Stracchino
On 10/18/10 07:21, Holikar, Sachin (ext) wrote: Hi Bruno, You hit the bullz eye!! I read both the scripts make_catalog_backup delete_catalog_backup. Found that previous admin has modified this script. After the statement , mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Damian Ge ; bicki
Phil Stracchino wrote: On 10/18/10 07:21, Holikar, Sachin (ext) wrote: Well, without seeing the script, we're somewhat guessing. Personally, I keep my catalog dumps around because if something crashes my database, it's faster to just reload the last database than to do a bscan. However, I'm

Re: [Bacula-users] bcp, Bacula CoPy

2010-10-18 Thread Geert Stappers
Op 20101018 om 03:45 schreef Dan Langille: On 10/11/2010 4:55 AM, Geert Stappers wrote: bcp, Bacula CoPy, copies files from one bacula file daemon to another bacula-fd. Reading from the source computer is like making a backup and writting to the destination is like doing a restore. So

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Phil Stracchino
On 10/18/10 08:08, Damian Ge;bicki wrote: Phil Stracchino wrote: On 10/18/10 07:21, Holikar, Sachin (ext) wrote: Well, without seeing the script, we're somewhat guessing. Personally, I keep my catalog dumps around because if something crashes my database, it's faster to just reload the last

[Bacula-users] Bscan bug?

2010-10-18 Thread Alan Brown
5.03, 64 bit It looks like bscan isn't referring to the changer device for a given tape drive in order to work out what slots to use. # bscan -m -s -V AMED0001\|AMED0002\|AMED0003\|AMED0004\|AMED0005\|AMED0006\|AMED0007 MSL6000-0 bscan: butil.c:281 Using device: MSL6000-0 for reading. 18-Oct

Re: [Bacula-users] bcp, Bacula CoPy

2010-10-18 Thread Dan Langille
On Oct 18, 2010, at 8:26 AM, Geert Stappers geert.stapp...@vanadgroup.com wrote: Op 20101018 om 03:45 schreef Dan Langille: On 10/11/2010 4:55 AM, Geert Stappers wrote: bcp, Bacula CoPy, copies files from one bacula file daemon to another bacula-fd. Reading from the source computer

Re: [Bacula-users] Bacula mysql cleanup

2010-10-18 Thread Alan Brown
Holikar, Sachin (ext) wrote: You are right Alan. It's a database dump file. So you mean to say that I can compress the current file and rename it. So that next time Mysql will start writing onto new bacula.sql file? Yes, but see Bruno's post on this - which also shows you how to change

Re: [Bacula-users] bcp, Bacula CoPy

2010-10-18 Thread Sean Clark
On 10/18/2010 07:26 AM, Geert Stappers wrote: Op 20101018 om 03:45 schreef Dan Langille: On 10/11/2010 4:55 AM, Geert Stappers wrote: bcp, Bacula CoPy, copies files from one bacula file daemon to another bacula-fd. Reading from the source computer is like making a backup and writting

Re: [Bacula-users] [Bacula-devel] Bscan bug?

2010-10-18 Thread Kern Sibbald
If I remember right, bscan does not support autochangers, because it has no idea what Volume belongs in what slot. You must manually (e.g. by mtx commands) change the Volumes when it asks you. Kern On Monday 18 October 2010 15:20:11 Alan Brown wrote: 5.03, 64 bit It looks like bscan isn't

[Bacula-users] Bacula 5.0.3 attempting to clone to tape with inchanger=0

2010-10-18 Thread Dylan Vanderhoof
I'm running into an issue with my offsite pools that are being rotated out. Our environment is that we have a File backup which clones to an Offsite pool when the main backups are complete. We have 4 sets of Offsite tapes which are rotated out of an autochanger weekly. When a volume becomes

Re: [Bacula-users] only incremental Backup of a growing amount of data

2010-10-18 Thread Martin Simmons
On Sun, 17 Oct 2010 22:01:42 +0200, Sebastian Gutweiler said: Hi, I have the following situation: - A data storage server (4TB) with a growing amount of scientific data. Data which is already on the server will probably stay there and only occasionally some will be deleted. A

Re: [Bacula-users] get_file_record want 1 got rows=2 after migration from MySQL to PostgreSQL

2010-10-18 Thread Martin Simmons
On Mon, 18 Oct 2010 09:54:28 +0200, Robert Oschwald said: I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, and then migrated to PostgreSQL 8.2 using dump/restore. ...snip... Migration from PostgreSQL 8.1 to 8.2: pg_dumpall pg_dump.sql - install postgreSQL 8.2

Re: [Bacula-users] only incremental Backup of a growing amount of data

2010-10-18 Thread Phil Stracchino
On 10/18/10 14:22, Martin Simmons wrote: On Sun, 17 Oct 2010 22:01:42 +0200, Sebastian Gutweiler said: - If I use small volume files, the old volume files won't be deleted/reused because they will contain files which are still on the storage server. Yes. Restore using incrementals needs

Re: [Bacula-users] LTO4 positioning time.

2010-10-18 Thread Andrea Venturoli
On 10/11/10 22:20, Panagiotis Christias wrote: Same setup here (FreeBSD 7.3 amd64, HP LTO-4), same problem until we paid more attention to the notes that come with bacula-server port (see pkg-message.server.in in /usr/ports/sysutils/bacula-server/files). Our working bacula-sd.conf