Re: [Bacula-users] mysqldump using fifo
+-le 28/10/2005 19:03 +0200, Kern Sibbald écrivait : | On Friday 28 October 2005 18:38, Martin Simmons wrote: |> > On Fri, 28 Oct 2005 11:13:30 +0200, Kern Sibbald <[EMAIL PROTECTED]> |> > said: |> |> Kern> On Friday 28 October 2005 10:59, Martin Simmons wrote: |> >> > On Fri, 28 Oct 2005 08:28:31 +0700, "frank" <[EMAIL PROTECTED]> |> >> > said: |> |> frank> I cannot get MySQL fifo backups to work. If I run the |> frank> backup job it hangs forever waiting for the input. If I |> frank> run the job manually from the shell it works without |> frank> problems. What is going on? |> |> frank> ... |> |> frank> #!/bin/sh |> |> frank> database=mydb |> frank> user=root |> frank> password="***" |> frank> fifo=/backup/fifo/MyDatabase |> |> frank> case "$1" in |> frank> before) |> frank> echo Before backup job processing... |> frank> rm -f $fifo 2>&1 < /dev/null |> frank> mkfifo $fifo 2>&1 < /dev/null |> frank> echo Dumping $database to fifo: $fifo |> frank> mysqldump --user=$user --password=$password $database & > |> |> >> $fifo 2>&1 < /dev/null frank> echo Done. |> |> frank> ;; |> frank> after) |> frank> echo After backup job processing... |> frank> rm -f $fifo 2>&1 < /dev/null |> frank> echo Done. |> frank> ;; |> frank> esac |> |> >> Is the mysqldump process still there when the job is hanging? |> >> |> >> What happens if you remove 2>&1? I don't see the point in redirecting |> >> stderr to the fifo anyway, but also it will hide any error messages on |> >> the tape :-) |> |> Kern> In addition, I don't see any need to redirect /dev/null to the |> input for rm, Kern> mkfifo, and mysqldump. |> |> It might be worthwhile for mysqldump, because that is backgrounded so |> doesn't want to be connected to the stdin of the script? | | Yes, this is a good point. In fact, it might even be worth while to try: | | mysqldump --user=$user --password=$password $database >$fifo 2>/dev/null | http://www.jboss.com/services/certification for more information ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Changes in fileset
+-le 19/01/2006 10:55 -0200, Pedro Henrique Morsch Mazzoni a dit : | Hi, | | I have changed a fileset and now bacula increases the level of backup from | incremental to full. | But I did'nt changed the name of the fileset. I just included one more | directory to backup. | Every time I include or exclude a directory from a fileset it will increase | the level of backup? | The problem is that I have a cycle backup with a recycling scheme, and when | it increase the level unexpectly it mess up all my scheme. | Any sugestions? I do things like this : FileSet { Name = "system" Include { Options { signature=SHA1; compression=GZIP; sparse=yes; } File = http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Changes in fileset
+-Le 19/01/2006 16:27 +, Martin Simmons a dit : |>>>>> On Thu, 19 Jan 2006 14:20:00 +0100, Mathieu Arnold <[EMAIL PROTECTED]> said: | | Mathieu> +-le 19/01/2006 10:55 -0200, Pedro Henrique Morsch Mazzoni a | dit : Mathieu> | Hi, | Mathieu> | | Mathieu> | I have changed a fileset and now bacula increases the level | of backup from Mathieu> | incremental to full. | Mathieu> | But I did'nt changed the name of the fileset. I just | included one more Mathieu> | directory to backup. | Mathieu> | Every time I include or exclude a directory from a fileset | it will increase Mathieu> | the level of backup? | Mathieu> | The problem is that I have a cycle backup with a recycling | scheme, and when Mathieu> | it increase the level unexpectly it mess up | all my scheme. Mathieu> | Any sugestions? | | Mathieu> I do things like this : | | Mathieu> FileSet { | Mathieu> Name = "system" | Mathieu> Include { | Mathieu> Options { signature=SHA1; compression=GZIP; sparse=yes; } | Mathieu> File = File = \ } | Mathieu> Exclude { | Mathieu>File = File = \ } | Mathieu> } | | Mathieu> So that there's master files on the director and local | changeable files on Mathieu> the client. | | Beware that if you add anything to /usr/local/etc/bacula/system or remove | anything from /usr/local/etc/bacula/system.exclude, those files will not | be backed up until the next Full backup unless they are new files. Yes, that's what I want :-) -- Mathieu Arnold --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Cleanly removing a client
+-le 11/02/2006 15:45 +0100, Frank Altpeter écrivait : | Hi list, | | I'm about to remove two machines from my bacula configuration because | they have been shut down. Because the last time i had to remove a | machine, it seemed to went a big wrong, i think i should ask for the | best way to do it. | So: What's the best (most clean and accurate) way to remove a client | from bacula? | | Because, if i just remove it from the configuration files, it won't | remove the already made backups since there is no chance to prune | them. Also, the database gets never cleaned up because the client | never gets called again when out of configuration. | | Last time i tried to use dbcheck to clean up the database from | obsolete entries, it took about 5 days to run and had to be aborted, | so i don't think this is an option. | | Any hints welcome... I usually just remove the jobs concerned, and after a time, when the backuped data won't be needed, I just remove the client entries. -- Mathieu Arnold --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Re: [Bacula-devel] Beta version 1.38.6-beta3-20060304 released
+-le 06/03/2006 11:16 +0100, Erik P. Olsen a dit : | Dan Langille wrote: |> I just installed it (as part of creating a FreeBSD port for this) and |> I had to |> mention that I like the changes to the job output. Specifically, the |> elapsed |> time and the human readable size values. |> | [snip] |> FD Bytes Written: 5,037,640,936 (5.037 GB) |> SD Bytes Written: 5,038,060,584 (5.038 GB) | [snip] | Actually, the size in Bytes should be divided by 2 to the power of 30 | rather than 10 to the power of 9 to produce the size in GB. This would | yield 4.692 GB in both cases. Actually, no. Both are ok, from the SI point of view.<http://en.wikipedia.org/wiki/Gigabyte> -- Mathieu Arnold --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Dayling saving time change
Hello, Earlier, this morning, here in France, we leaped from 1:59:59 to 3:00:00, I had all my jobs scheduled between 2:05 and 2:20, and they did not run :-( On the other hand I had cron jobs at 2:30, and they ran (at 3, yeah, but they ran). I was wondering if that, hum, bug, could be fixed in any next version of bacula :-) (hopefully, when time goes the other way round, the jobs are only ran once). -- Mathieu Arnold --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Dayling saving time change
+-le 27/03/2005 10:05 +0200, Mathieu Arnold a dit : | Hello, | | Earlier, this morning, here in France, we leaped from 1:59:59 to 3:00:00, I | had all my jobs scheduled between 2:05 and 2:20, and they did not run :-( | On the other hand I had cron jobs at 2:30, and they ran (at 3, yeah, but | they ran). | I was wondering if that, hum, bug, could be fixed in any next version of | bacula :-) | (hopefully, when time goes the other way round, the jobs are only ran | once). I know that in the US, the daylight change is next Sunday, but am I the only one to experience this issue ? -- Mathieu Arnold --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File number
+-le 07/04/2005 12:41 +, Francesco a dit : | After a backup the report says there are 51.084 files written, but if i ask | the proprieties of this folder there are only 45.107 files. And if you count the directories ? -- Mathieu Arnold --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Re: Paris
+-le 10/05/2005 16:14 +0200, Kern Sibbald écrivait : | On Tuesday 10 May 2005 11:44, Romain wrote: |> > Hello, |> > |> > If any of you are in Paris tomorrow evening (Tuesday 11 May) around 7pm, |> > I would like to invite you to dinner (certain limitations on the number |> > of people). This is a bit of short notice, sorry. Please let me know if |> > that interests you. |> |> I'd love to meet you as i am testing Bacula and my managers seem |> to be convinced by this software. |> But I work in Angers (1h30 far from Paris by TGV) and can't come. | | Thanks for letting me know. Perhaps some other time. Too bad I was away to vacation in Canada and to BSDCan in Ottawa. I'd have loved to meet you. |> |> > Je parle français, mais je ne suis pas assez doué à l'écrire. |> |> C'est déjà bien de parler français vu le nombre de français qui parlent |> correctement anglais ;-) | | Je prefère parler français où les petites erreurs son vite perdues. Par | écrit, toutes les erreurs sautent de la page ... (au moins pour les | francophones). Écrire français, même avec des fautes n'est pas si grave que ça :-) -- Mathieu Arnold --- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_idt12&alloc_id344&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] migration sqlite > postgresql
+-le 23/09/2005 15:01 +0200, Florian Schnabel écrivait : | now ... i decided to migrate to postgresql ... | did set up the database and tried to import the .sql | about every line gives an error ^^ | | f.ex. | | psql:/var/lib/bacula/test.sql:8: FEHLER: Fehler »Syntaxfehler« bei | »UNSIGNED« at character 44 | psql:/var/lib/bacula/test.sql:8: ZEILE 2:BaseId INTEGER UNSIGNED | AUTOINCREMENT, | | is there any way to convert it so postgres likes it ? | don't really want to start with an empty database ... You will have to create the database with the scripts coming with bacula, it's not the same script for sqlite and postgresql (not the same keywords, semantic, etc...) Then, you'll have some problem with the time fields, as sqlite makes some strange things in some rare cases. I've already done that migration twice, and it's the only thing I do remember. After the import, you'll have to set the sequences to the right number for each table so that you don't run into conflicting id's. Regards, -- Mathieu Arnold --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-users-fr] Web site now translated into French
+-Le 23/07/06 14:36 +0200, Kern Sibbald a dit : | www.bacula.org/fr I'll make bacula.fr redirect to that instead of www.bacula.org as soon as I'm back from vacations (which should be after tomorrow). -- Mathieu Arnold - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users