Re: [Bacula-users] mysql database: table batch
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 existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) " 2008/10/7 Hösch Roland <[EMAIL PROTECTED]>: > Hello, > > I'm using bacula 2.4.1 on ubuntu 8.04. > > I'm doing backups of different clients, which are working. > But the backup of one client (my server: this is where director, fd, sd and > mysql are running), which is the largest amount of data to be saved, failes: > > nas-fd JobId 1603: /music is a different filesystem. Will not descend > from / into /music > 07-Okt 08:01 nas-dir JobId 1603: Fatal error: sql_create.c:732 > sql_create.c:732 insert INSERT INTO batch VALUES > (400500,1603,'/','vmlinuz.old','gC MAD KH/ B A A A d BAA A BI6d8W BHXVoe > BIbMDj A A E','0') failed: > Table 'bacula.batch' doesn't exist > 07-Okt 08:01 nas-dir JobId 1603: sql_create.c:732 INSERT INTO batch VALUES > (400500,1603,'/','vmlinuz.old','gC MAD KH/ B A A A d BAA A BI6d8W BHXVoe > BIbMDj A A E','0') > 07-Okt 08:01 nas-dir JobId 1603: Fatal error: catreq.c:413 Attribute create > error. No prior Full backup Job record found. > > THis is strange, because there is no table batch within the database bacula. > > Is there a problem with the version of my bacula mysql database? > > Thanks, Roland > > - > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- with best regards - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] mysql database problem
If I understand your question properly, I believe the answer can be found here: http://www.bacula.org/rel-manual/Catalog_Maintenance.html > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Bernhard Suttner > Sent: Tuesday, 14 June, 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 <[EMAIL PROTECTED]> wrote: > > > Hello Bacula Users, > > > > i have installed the bacula backup system with one server > and some clients over a network. All programms works great, > but i have a small problem: the mysql database is _really_ > big. I have nearly 55 GB of backup files and the database > grow up to nearly 250 GB. Is that usual? Do I need so a big > database, that I can have a bacula running without trouble? > > > > Thank you > > > > greets, > > Bernhard Suttner > > > > > > --- > > This SF.Net email is sponsored by: NEC IT Guy Games. How > far can you > > shotput a projector? How fast can you ride your desk chair > down the office luge track? > > If you want to score the big prize, get to know the little guy. > > Play to win an NEC 61" plasma display: > http://www.necitguy.com/?r=20 > > ___ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > -- > Bernhard Suttner <[EMAIL PROTECTED]> > > ANDURAS service solutions AG > Innstraße 71 - 94036 Passau - Germany > Web: www.anduras.de - Tel: +49 (0)851-4 90 50-0 - Fax: +49 > (0)851-4 90 50-55 > > Rechtsform: Aktiengesellschaft - Sitz: Passau - Amtsgericht > Passau HRB 6032 Mitglieder des Vorstands: Sven Anders, Marcus > Junker, Michael Schön Vorsitzender des Aufsichtsrats: Dipl. > Kfm. Thomas Träger > > > --- > This SF.Net email is sponsored by: NEC IT Guy Games. How far > can you shotput a projector? How fast can you ride your desk > chair down the office luge track? > If you want to score the big prize, get to know the little guy. > Play to win an NEC 61" plasma display: > http://www.necitguy.com/?r > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
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 <[EMAIL PROTECTED]> wrote: > Hello Bacula Users, > > i have installed the bacula backup system with one server and some clients > over a network. All programms works great, but i have a small problem: the > mysql database is _really_ big. I have nearly 55 GB of backup files and the > database grow up to nearly 250 GB. Is that usual? Do I need so a big > database, that I can have a bacula running without trouble? > > Thank you > > greets, > Bernhard Suttner > > > --- > This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput > a projector? How fast can you ride your desk chair down the office luge track? > If you want to score the big prize, get to know the little guy. > Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Bernhard Suttner <[EMAIL PROTECTED]> ANDURAS service solutions AG Innstraße 71 - 94036 Passau - Germany Web: www.anduras.de - Tel: +49 (0)851-4 90 50-0 - Fax: +49 (0)851-4 90 50-55 Rechtsform: Aktiengesellschaft - Sitz: Passau - Amtsgericht Passau HRB 6032 Mitglieder des Vorstands: Sven Anders, Marcus Junker, Michael Schön Vorsitzender des Aufsichtsrats: Dipl. Kfm. Thomas Träger --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] mysql database problem
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 take a while... Bernhard Suttner wrote: > Hello Bacula Users, > > i have installed the bacula backup system with one server and some clients > over a network. All programms works great, but i have a small problem: the > mysql database is _really_ big. I have nearly 55 GB of backup files and the > database grow up to nearly 250 GB. Is that usual? Do I need so a big > database, that I can have a bacula running without trouble? > > Thank you > -- Ivan Ivanyi Swiss Institute of Bioinformatics 1, rue Michel Servet CH-1211 Genève 4 Switzerland Tel: (+41 22) 379 58 33 Fax: (+41 22) 379 58 58 E-mail: [EMAIL PROTECTED] PGP signature http://www.expasy.org/people/Ivan.Ivanyi.gpg --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] MySQL Database
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? > > No. You don't have any way to guarantee that the database isn't > corrupt. > > SNIP > > OK, but assuming mySQL is backed up properly, and I have a copy of the > BSR file for each of my backups, can I rebuild the bacula database in > the event of a crash? > If you've got your database backed up, you dont need to do anything special to restore bacula's database - it's already there. Just restore them to mysql with the appropriate mysql utilities. The BSR file just contains a bunch of references to what is in the DB and is only useful for specifying what jobs/files/etc you want to work on. Have you looked at a BSR file? If you do, you'll see that they obviously contain insufficiant data to restore your database. My understanding is that one can repopulate bacula's database with the info about jobs contained in a given volume using the bscan utility. -davidc -- Real generosity toward the future lies in giving all to the present. -Albert Camus --- 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] MySQL Database
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 OK, but assuming mySQL is backed up properly, and I have a copy of the BSR file for each of my backups, can I rebuild the bacula database in the event of a crash? Thanks, Quintin --- 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_ide95&alloc_id396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
RE: [Bacula-users] MySQL Database
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 OK, but assuming mySQL is backed up properly, and I have a copy of the BSR file for each of my backups, can I rebuild the bacula database in the event of a crash? Thanks -- Phil Brutsche [EMAIL PROTECTED] --- 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_ide95&alloc_id396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MySQL Database
(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 history on my previous backupswhat I need to know, is this sufficient? For testing purposes it may work out OK, but for a production database? No. The best way to back up MySQL is listed in the MySQL reference manual: http://dev.mysql.com/doc/mysql/en/disaster-prevention.html 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. -- Phil Brutsche [EMAIL PROTECTED] --- 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] MySQL Database
-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/directory does NOT exist on my machine. 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 not a good idea. You are backing up the live MySQL database (and by backing it up, writting to it at the same time!) and thus risking to get an inconsistent state of it. To get a proper backup, you should export/dump the database just before backing it up and write that dump to the tape (the default setup should be doing this, if it doesn't, check the make_catalog_backup script which is invoked with the RunBeforeJob directive). Greetings, Michel -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) - GPGrelay v0.958 iD8DBQFCUsRX2Vs+MkscAyURAqe5AJsHjQ6rm/ayr7BfxoQrAt2YTkv9IgCfQGx5 u6g4l+kix2+yus3yApQElAE= =yOe7 -END PGP SIGNATURE- --- 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] MySQL Database
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 yourself) so that you have it on another machine in the event your catalog is lost. You can then rebuild the catalog from the backups using the bootstrap file, and then proceed to run the other restore jobs to get the other data you have backed up. Ben --- Benjamin Chambers, P.Eng. ClarkConnect Account Manager www.clarkconnect.com Point Clark Networks 642 King Street West, Suite 200 Toronto, ON Canada, M5V 1N9 Tel: +1.416.977.0574 Ext. 111 Fax: +1.416.946.1192 Email: [EMAIL PROTECTED] 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/directory does NOT exist on my machine. 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 history on my previous backupswhat I need to know, is this sufficient? 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? i.e. I would be able to restore previously backed up jobs? Thanks for any advice on this, Quintin Giesbrecht IT Professional Hanover School Division [EMAIL PROTECTED] --- 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_ide95&alloc_id396&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users --- 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
