Re: [Bacula-users] Problem when canceling a job
2013/3/21 Sergio Belkin : > Hi folks, > > I am facing a strange problem whenever I cancel a job, then the > following message it appears: > > clair.example.edu-sd JobId 7477: Error: Unable to position to end of > data on device "LTO5" (/dev/IBMtape0n): ERR=dev.c:786 ioctl MTIOCGET > error on "LTO5" (/dev/IBMtape0n). ERR=Success. > > 21-mar 11:16 clair.example.edu-sd JobId 7477: Marking Volume > "LUNMAR2013LTO5" in Error in Catalog. > > Any ideas? > > Thanks in advance! > -- > -- I was told that the problem is the driver: lin_tape 1.76.0 SAS info: lin_tape version: 1.76.0 lin_tape major number: 251 Attached Tape Devices: Number model SNHBA SCSIFO Path 0 ULT3580-HH5 1068049105Fusion MPT SAS Host3:0:0:0 NA And is using /dev/IBMtape* block devices, May be that the problem? Thanks in advance -- -- Sergio Belkin http://www.sergiobelkin.com Watch More TV http://sebelk.blogspot.com LPIC-2 Certified - http://www.lpi.org -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On 03/21/13 08:43, Konstantin Khomoutov wrote: > On Thu, 21 Mar 2013 07:40:01 -0400 > Phil Stracchino wrote: > > [...] >> Try this for a faster method: >> >> CREATE TABLE NewFile LIKE File; >> INSERT INTO NewFile (SELECT * FROM File); >> DROP TABLE File; >> RENAME TABLE NewFile TO File; > > I think the "ALTER TABLE" step is missing, and this should be: > > CREATE TABLE NewFile LIKE File; > ALTER TABLE NewFile ENGINE=InnoDb; Right. I tend to forget that because I simply never use MyISAM, for *anything*. (Except of course the grant tables, and that only until MySQL grant tables can be sotred in InnoDB.) -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Question about Catalog Backup
On Mar 20, 2013, at 3:43 PM, John Drescher wrote: >> I've readn an example in the documentation as follows: >> >> >> RunBeforeJob = "/home/kern/bacula/bin/make_catalog_backup" >> RunAfterJob = "/home/kern/bacula/bin/delete_catalog_backup" >> >> I don't understand it performs a backup and then deletes it? Am I >> missing something? >> > > This dumps a text file. Then bacula makes a backup of the text file > and finally it deletes the text file since it does not need it since > it will be in the backup.. I recommend not deleting the text file for two reasons: 1 - it reserves the space for the next dump 2 - it keeps an extra copy of the dump, in case you need it. -- Dan Langille - http://langille.org -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Windows client backup: VSS and/or ntbackup?
Hello, On 21 March 2013 16:14, Christoph Litauer wrote: > So I wonder if VSS won't fit my needs _without_ doing a ntbackup > systemstate with clientRunBeforeJob? Will a VSS backup of partition C: save > all system relevant information (registry etc.) for disaster recovery? > I've succesfully restored many Windows systems using only VSS. The only thing you will have on Windows Server variants is the popup window with the "unexpected shutdown" message stating that the system was not shutdown properly. Regards, --Simone -- You cannot discover new oceans unless you have the courage to lose sight of the shore (R. W. Emerson). -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Windows client backup: VSS and/or ntbackup?
How about dedupe/base jobs as well? On Mar 21, 2013, at 12:09 PM, "Chris Adams" wrote: > Once upon a time, Christoph Litauer said: >> This works but has two ceveats: ntbackup runs several minutes even on an >> unused system and the resulting backup is severeal gb every day. > > It sounds like you are not excluding things you should exclude. An > incremental backup of an unused system should not be several GB/day. > > Something like this should help (but remember that changing the > include/exclude will cause the next backup to be promoted to a full > backup): > > Options { ># Windows is case-preserving, NOT case-sensitive >Ignore Case = yes >Exclude = yes > ># general Windows stuff >wilddir = "c:/Windows/$NtServicePackUninstall$" >wilddir = "c:/Windows/$NtUninstall*" >wilddir = "c:/Windows/Installer/$PatchCache$" >wilddir = "c:/Windows/ServicePackFiles" >wilddir = "c:/Windows/SoftwareDistribution/Download" >wilddir = "c:/Windows/Temp" > ># per drive >wilddir = "[a-z]:/$Recycle.Bin" >wilddir = "[a-z]:/RECYCLER" >wilddir = "[a-z]:/System Volume Information" >wilddir = "[a-z]:/pagefile.sys" > } > > The biggest things that will hit incremental backups of unused systems > are the last two in the list. The "System Volume Information" directory > is where VSS information is stored, so it can be large during the > backup. Also, any activity (such as running ntbackup) can cause changes > in pagefile.sys, which will cause the whole file to be included in the > backup (and it can also be big). > > Now, I have a question of my own related to this: ntbackup is gone in > newer versions of Windows. What are people using to do the equivalent > of "ntbackup backup systemstate" there? > -- > Chris Adams > Systems and Network Administrator - HiWAAY Internet Services > I don't speak for anybody but myself - that's enough trouble. > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_mar > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Windows client backup: VSS and/or ntbackup?
Once upon a time, Christoph Litauer said: > This works but has two ceveats: ntbackup runs several minutes even on an > unused system and the resulting backup is severeal gb every day. It sounds like you are not excluding things you should exclude. An incremental backup of an unused system should not be several GB/day. Something like this should help (but remember that changing the include/exclude will cause the next backup to be promoted to a full backup): Options { # Windows is case-preserving, NOT case-sensitive Ignore Case = yes Exclude = yes # general Windows stuff wilddir = "c:/Windows/$NtServicePackUninstall$" wilddir = "c:/Windows/$NtUninstall*" wilddir = "c:/Windows/Installer/$PatchCache$" wilddir = "c:/Windows/ServicePackFiles" wilddir = "c:/Windows/SoftwareDistribution/Download" wilddir = "c:/Windows/Temp" # per drive wilddir = "[a-z]:/$Recycle.Bin" wilddir = "[a-z]:/RECYCLER" wilddir = "[a-z]:/System Volume Information" wilddir = "[a-z]:/pagefile.sys" } The biggest things that will hit incremental backups of unused systems are the last two in the list. The "System Volume Information" directory is where VSS information is stored, so it can be large during the backup. Also, any activity (such as running ntbackup) can cause changes in pagefile.sys, which will cause the whole file to be included in the backup (and it can also be big). Now, I have a question of my own related to this: ntbackup is gone in newer versions of Windows. What are people using to do the equivalent of "ntbackup backup systemstate" there? -- Chris Adams Systems and Network Administrator - HiWAAY Internet Services I don't speak for anybody but myself - that's enough trouble. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Windows client backup: VSS and/or ntbackup?
Dear bacula users, we use bacula for some years now, excellent tool! But there is one open question I was not able to answer 'til today: Doing windows (XP)-client backups I need the possibility to do a disaster recovery. My solution (tested successfully) is 1.) Do "ntbackup backup systemstate /F c:\systemstate.bkf" using ClientRunBeforeJob 2.) Do a bacula backup using VSS including c:\systemstate.bkf Disaster recovery then is 1.) Install a minimal windows client 2.) restore c: using bacula (includes systemstate.bkf) 3.) restore systemstate using ntbackup on the client 4.) reboot This works but has two ceveats: ntbackup runs several minutes even on an unused system and the resulting backup is severeal gb every day. So I wonder if VSS won't fit my needs _without_ doing a ntbackup systemstate with clientRunBeforeJob? Will a VSS backup of partition C: save all system relevant information (registry etc.) for disaster recovery? -- Kind regards Christoph _ Christoph Litauer Uni Koblenz, Computing Centre, Office A 022 Postfach 201602, 56016 Koblenz Fon: +49 261 287-1311, Fax: -100 1311 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup of Windows7 PC does not work
On Sunday 17 March 2013 21:26:24 Silver Salonen wrote: > On Sunday 17 March 2013 19:32:02 Jean-Gabriel Duquesnoy wrote: > > Hi, > > > > I think this is an easy question, but I have not found the response to > > it anywhere, despite having searched for some days now. > > The backup from my Linux works perfectly, but for the windows7 PC, > > this is what I get: > > 17-Mär 19:13 duke40-pc-fd JobId 15: Fatal error: No drive letters found > > for generating VSS snapshots. > > 17-Mär 19:13 duke40-pc-fd JobId 15: Error: VSS API failure calling > > "BackupComplete". ERR=Object is not initialized; called during restore > > or not called in correct sequence. > > 17-Mär 19:12 mail-sd JobId 15: Job write elapsed time = 00:00:15, > > Transfer rate = 0 Bytes/second > > 17-Mär 19:12 mail-sd JobId 15: JobId=15 > > Job="Backupduke40.2013-03-17_19.11.53_03" marked to be > > canceled. > > 17-Mär 19:12 mail-dir JobId 15: Error: Bacula mail-dir 5.0.2 (28Apr10): > > 17-Mär-2013 19:12:11 > > Build OS: i486-pc-linux-gnu debian 6.0.3 > > JobId: 15 > > Job:Backupduke40.2013-03-17_19.11.53_03 > > Backup Level: Full (upgraded from Incremental) > > Client: "duke40-pc-fd" 5.2.10 (28Jun12) Microsoft Windows > > 7 Starter Edition Service Pack 1 (build 7601), 32-bit,Cross- > > compile,Win32 > > FileSet:"Full Set" 2013-03-16 20:19:57 > > Pool: "File" (From Job resource) > > Catalog:"MyCatalog" (From Client resource) > > Storage:"File" (From Job resource) > > Scheduled time: 17-Mär-2013 19:11:52 > > Start time: 17-Mär-2013 19:11:56 > > End time: 17-Mär-2013 19:12:11 > > Elapsed time: 15 secs > > > > I think I might use a different syntax in the bacula-dir.conf file for File > > attribute of the FileSet. Can someone give me a hint. > > Hi. > > I've been seeing it lately quite often and it happens quite randomly for both > Windows 7 and Windows 2008 servers. There are some machines that have this > problem more frequently than the other, but I've not yet figured it out why > is that. I hope I'll be able to track it a bit more in the following week. Unfortunately we did not find anything concrete and googling was not of very much help this time either. So I just disabled VSS for that problematic job :( Sorry to disappoint. -- Silver -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
>>> ok I brutally "solve" the problem: >>> mt -f /dev/st0 rewind >>> mt -f /dev/st0 weof >>> label >>> >> >> No barcode reader? >> If your archive has a barcode reader it is highly recommended that you use barcode labels and use the barcode functionality builtin to bacula otherwise when you add or remove tapes bacula must load every tape in the archive so that it knows what volumes are in what slots. This will take a long time on large archives. In the case where you have a barcode reader and all of your tapes have barcode labels update slots takes no time at all. Although the archive itself will take some time (but much less than loading each tape) cataloging the tapes. Then to label your tapes in bacula you do not use the label command you would instead issue the label barcodes command and I recommend you put the tapes in the Scratch pool. John -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Problem when canceling a job
Hi folks, I am facing a strange problem whenever I cancel a job, then the following message it appears: clair.example.edu-sd JobId 7477: Error: Unable to position to end of data on device "LTO5" (/dev/IBMtape0n): ERR=dev.c:786 ioctl MTIOCGET error on "LTO5" (/dev/IBMtape0n). ERR=Success. 21-mar 11:16 clair.example.edu-sd JobId 7477: Marking Volume "LUNMAR2013LTO5" in Error in Catalog. Any ideas? Thanks in advance! -- -- Sergio Belkin http://www.sergiobelkin.com Watch More TV http://sebelk.blogspot.com LPIC-2 Certified - http://www.lpi.org -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + arbitrary backup on tape
Le 21/03/2013 14:34, Sven Tegethoff a écrit : > On 21.03.2013 13:57, giggzounet wrote: >> mailslot1 (Slot=46) : name of the new volume: FSI-PfS-1a_1__1 >> mailslot2 (Slot=47) : name of the new volume: FSI-PfS-1a_1__2 >> mailslot3 (Slot=48) : name of the new volume: FSI-PfS-1a_1__3 >> >> the problem is in bconsole a "list media" always gives the old "FSI-LES" >> in the slot 46. And of course it generates some errors, when I want to >> use it to bakcup. >> >> How can I solve this problem ? > > Did you do a "update slots" (or "update slots scan" if you're not using > barcodes) after exchanging the tapes? > Hi, I did not do that, after removing the tape. But after exchanging the tapes and it doesn't work. I get an error on the slot 46: 3307 Issuing autochanger "unload slot 45, drive 0" command. 3304 Issuing autochanger "load slot 46, drive 0" command. 3305 Autochanger "load slot 46, drive 0", status is OK. 3001 Volume=FSI-PfS-1a_1__1 Slot=46 Volume "FSI-PfS-1a_1__1" not found in catalog. Slot=46 InChanger set to zero. Best regards -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
Le 21/03/2013 14:41, Gary R. Schmidt a écrit : > On 22/03/2013 12:18 AM, giggzounet wrote: >> Hi, >> >> Our tape library is full with tapes. One tape is invisible: the tape on >> slot 5. I can mount it. When I try to relabel it, I'm seeing the right >> label...but I can not see it in the "list media" in bconsole. >> >> An idea to solve that ? >> > Does "update slots" find it? > No it did not. but rewin, weof + label worked. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
Le 21/03/2013 15:02, John Drescher a écrit : >> ok I brutally "solve" the problem: >> mt -f /dev/st0 rewind >> mt -f /dev/st0 weof >> label >> > > No barcode reader? > > John > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_mar I don't think so. How can I know that ? -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On Thu, 21 Mar 2013 14:46:04 +0100 Uwe Schuerkamp wrote: > > CREATE TABLE NewFile LIKE File; > > INSERT INTO NewFile (SELECT * FROM File); > > DROP TABLE File; > > RENAME TABLE NewFile TO File; > > > > Thanks Phil, I was a bit anxious about the select into bit because the > server ran out of memory before when I tried to create a > postgres-compatible dump using mysqldump, so it was important for me > to create a fully consistent dump of the file table first for backup > purposes. I'm curious about how to do such a Postgres-compatible dump? Could you please share this? -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
> ok I brutally "solve" the problem: > mt -f /dev/st0 rewind > mt -f /dev/st0 weof > label > No barcode reader? John -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + arbitrary backup on tape
On 21.03.2013 13:57, giggzounet wrote: > mailslot1 (Slot=46) : name of the new volume: FSI-PfS-1a_1__1 > mailslot2 (Slot=47) : name of the new volume: FSI-PfS-1a_1__2 > mailslot3 (Slot=48) : name of the new volume: FSI-PfS-1a_1__3 > > the problem is in bconsole a "list media" always gives the old "FSI-LES" > in the slot 46. And of course it generates some errors, when I want to > use it to bakcup. > > How can I solve this problem ? Did you do a "update slots" (or "update slots scan" if you're not using barcodes) after exchanging the tapes? Best regards, Sven -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
On 21.03.2013 14:18, giggzounet wrote: > Hi, > > Our tape library is full with tapes. One tape is invisible: the tape on > slot 5. I can mount it. When I try to relabel it, I'm seeing the right > label...but I can not see it in the "list media" in bconsole. > > An idea to solve that ? It sounds like you accidently added it to the wrong pool or the wrong catalog (if you have more than one) when you labelled it the first time, or you deleted it from the pool after labelling it. The label command will refuse to label any tapes that still have a label on them. If you are sure the tape is REALLY not references anywhere in the catalog, you can first delete the label using: mt -f /dev/nst0 rewind mt -f /dev/nst0 weof Then use the "label" command to re-label the tape and automatically add the media to the catalogue. Make sure you loaded the correct tape from the magazine before doing this. Best regards, Sven -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
Le 21/03/2013 14:18, giggzounet a écrit : > Hi, > > Our tape library is full with tapes. One tape is invisible: the tape on > slot 5. I can mount it. When I try to relabel it, I'm seeing the right > label...but I can not see it in the "list media" in bconsole. > > An idea to solve that ? > > Thx > Cheers > Guillaume > > ok I brutally "solve" the problem: mt -f /dev/st0 rewind mt -f /dev/st0 weof label now I can see the tape. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + invisible tape
On 22/03/2013 12:18 AM, giggzounet wrote: > Hi, > > Our tape library is full with tapes. One tape is invisible: the tape on > slot 5. I can mount it. When I try to relabel it, I'm seeing the right > label...but I can not see it in the "list media" in bconsole. > > An idea to solve that ? > Does "update slots" find it? Cheers, GaryB-) -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MySQLdump import seems very slow for "Filename" and "Path" tables
On Tue, Mar 19, 2013 at 10:37:13AM -0500, Melvin Ross wrote: > You may also want to try Xtrabackup from Percona. > > -Melvin > Brilliant, thanks for the heads-up, Melvin! FWIW, in order to get xtrabackup to work with MariaDB 5.5, I had to add a [mysqld] section to my.cnf, pointing to the correct datadir location. Mydumper 2.x seems to be a bit of a mess, it fails to compile on centos 6.4 (cmake is apparently still used? ;). I've reported a bug on launchpad. Cheers, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On Thu, Mar 21, 2013 at 07:40:01AM -0400, Phil Stracchino wrote: > Try this for a faster method: > > CREATE TABLE NewFile LIKE File; > INSERT INTO NewFile (SELECT * FROM File); > DROP TABLE File; > RENAME TABLE NewFile TO File; > Thanks Phil, I was a bit anxious about the select into bit because the server ran out of memory before when I tried to create a postgres-compatible dump using mysqldump, so it was important for me to create a fully consistent dump of the file table first for backup purposes. All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula + invisible tape
Hi, Our tape library is full with tapes. One tape is invisible: the tape on slot 5. I can mount it. When I try to relabel it, I'm seeing the right label...but I can not see it in the "list media" in bconsole. An idea to solve that ? Thx Cheers Guillaume -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula + arbitrary backup on tape
Hi, I'm new on this list. We are using bacula on our cluster with an Overland Tape library with autochanger. Bacula is configured to do some backups every weeks. It works without problem. The tape library has "mailslots". I want to use these mailslots to do some extra arbitrary backups. In order to do that I have a special pool "scratch". I have labeled a tape "FSI-LES" in the mailslot1 (slot=46) and I backuped some files on it. Then I remove this tape. Now I want to do other arbitrary backups. I put 3 new blanks tapes and I label them in the "scratch" pool: mailslot1 (Slot=46) : name of the new volume: FSI-PfS-1a_1__1 mailslot2 (Slot=47) : name of the new volume: FSI-PfS-1a_1__2 mailslot3 (Slot=48) : name of the new volume: FSI-PfS-1a_1__3 the problem is in bconsole a "list media" always gives the old "FSI-LES" in the slot 46. And of course it generates some errors, when I want to use it to bakcup. How can I solve this problem ? How can I do some arbitrary backup on tape ? and then remove the tapes and add others one... Best regards, Guillaume -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On Thu, 21 Mar 2013 07:40:01 -0400 Phil Stracchino wrote: [...] > Try this for a faster method: > > CREATE TABLE NewFile LIKE File; > INSERT INTO NewFile (SELECT * FROM File); > DROP TABLE File; > RENAME TABLE NewFile TO File; I think the "ALTER TABLE" step is missing, and this should be: CREATE TABLE NewFile LIKE File; ALTER TABLE NewFile ENGINE=InnoDb; INSERT INTO NewFile (SELECT * FROM File); DROP TABLE File; RENAME TABLE NewFile TO File; Thanks for the tip -- used this approach today to reload my own catalog. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On 03/21/13 04:27, Uwe Schuerkamp wrote: > Hi folks, > > last night I managed to shrink a 300GB File table down to a very > reasonable 85GB by exporting, dropping and re-importing the table > (about 500 million rows). > > Dumping the table on an idle bacula server (see earlier posts for > machine specs) took around 90 minutes and resulted in a 55GB sql > file. Dropping the table was a breeze (about a minute or so), > re-importing took around 3 hours: > > > date ; time mysql -pn1onex bacula < file_2013_03_20.sql ; date > Mi 20. Mär 22:35:14 CET 2013 > > real165m12.748s > user15m17.358s > sys 1m2.320s > Do 21. Mär 01:20:27 CET 2013 > > Post-Import File table size: > > -rw-rw 1 mysql mysql 8,7K 20. Mär 22:35 File.frm > -rw-rw 1 mysql mysql 83G 21. Mär 01:20 File.ibd Try this for a faster method: CREATE TABLE NewFile LIKE File; INSERT INTO NewFile (SELECT * FROM File); DROP TABLE File; RENAME TABLE NewFile TO File; -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Send mail only to one address for one job.
2013/3/21 Christoph Litauer > > I do it like this: > In bacula-dir.conf define a new Message ressource using a different e-mail > address: > > Messages { > Name = "Message for 2 Jobs" > mailcommand = "/usr/sbin/bsmtp -h localhost -f \"Bacula > \\" -s \"Bacula: %t %e of %c %l\" %r" > mail = mailaddress.for.2.j...@yourdomain.de = all, !skipped > console = all, !skipped, !saved > append = "/var/log/bacula" = all, !skipped > } > > Then use this new ressource in the job ressources of your two jobs: > > Job { > ... > Messages = "Messages for 2 Jobs" > ... > } Thank you very much Christoph!! I will test this ;-) Manu -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrating from myisam to innodb
On Tue, Feb 26, 2013 at 04:24:02PM +, Alan Brown wrote: > On 26/02/13 09:42, Uwe Schuerkamp wrote: > > >I wonder if dumping the file table and then > >re-importing it to an innodb replacement would have been quicker? > > In general: Yes. > > Hi folks, last night I managed to shrink a 300GB File table down to a very reasonable 85GB by exporting, dropping and re-importing the table (about 500 million rows). Dumping the table on an idle bacula server (see earlier posts for machine specs) took around 90 minutes and resulted in a 55GB sql file. Dropping the table was a breeze (about a minute or so), re-importing took around 3 hours: date ; time mysql -pn1onex bacula < file_2013_03_20.sql ; date Mi 20. Mär 22:35:14 CET 2013 real165m12.748s user15m17.358s sys 1m2.320s Do 21. Mär 01:20:27 CET 2013 Post-Import File table size: -rw-rw 1 mysql mysql 8,7K 20. Mär 22:35 File.frm -rw-rw 1 mysql mysql 83G 21. Mär 01:20 File.ibd I hope you find this information useful when planning a migration from myisam to innodb. Feel free to post here if you have further questions or require more details. All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Send mail only to one address for one job.
Am 19.03.2013 um 10:34 schrieb Manuel Trujillo : > Hi! > > I would like to know if there is any possibility to send a mail about the > status of two jobs to a mail address different of the system mail (please, > excuse me my bad english :-/). > I do it like this: In bacula-dir.conf define a new Message ressource using a different e-mail address: Messages { Name = "Message for 2 Jobs" mailcommand = "/usr/sbin/bsmtp -h localhost -f \"Bacula \\" -s \"Bacula: %t %e of %c %l\" %r" mail = mailaddress.for.2.j...@yourdomain.de = all, !skipped console = all, !skipped, !saved append = "/var/log/bacula" = all, !skipped } Then use this new ressource in the job ressources of your two jobs: Job { ... Messages = "Messages for 2 Jobs" ... } -- Kind regards Christoph _ Christoph Litauer Uni Koblenz, Computing Centre, Office A 022 Postfach 201602, 56016 Koblenz Fon: +49 261 287-1311, Fax: -100 1311 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula and hyper-V
Op 2013-03-20 om 21:00 schreef Mike Eggleston: > On Mar 20, 2013, at 13:44, "Bachmatiuk, Marcin" wrote: > > > > Hello, > > > > I have question. > > Does anyone have an experiment one of the bacula backup and Hyper-V? > > > > Any solution.a > > > > --- > > Best regards Marcin > > I use bacula to backup Hyper-V slices. I have no errors. > > Mike > Which special configuration was needed, if any? Please, tell it to the mailinglist (archive). -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users