Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread Frank Sweetser
pichi wrote: > So to summarize: > > - if you have the sql file, you don't need the bsr > > - if you have the sql file, but it's buried somewhere in your backup > volumes, > the bsr is the best way to get at it quickly > > - if you don't have the sql file, you can fake it with bscan > > > Fr

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread pichi
So to summarize: - if you have the sql file, you don't need the bsr - if you have the sql file, but it's buried somewhere in your backup volumes, the bsr is the best way to get at it quickly - if you don't have the sql file, you can fake it with bscan Frank, Wow! That nails it for me. I u

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread Frank Sweetser
pichi wrote: > I did not modify anything and recovered the file with no problems. But my > question is why was I able to recover the file without the use of the > bootstrap file? I guess I am having conceptual problems because I though I > needed both the .bsr and the .sql file to rebuild or am I m

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread pichi
>The bacula.sql file is a snapshot of the database that holds the catalog. The >exact set of commands required to import it has to do with the database engine >you're running, and is completely outside of Bacula. For example, with mysql, >you'd launch the mysql shell, create the database, and

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread Frank Sweetser
pichi wrote: > Frank, > > Thanks for answering my post. I appreciate it very much. > > The reason I am not using BSCAN is in the documentation it says: > > "If you find yourself using this program, you have probably done something > wrong." In the strictest sense, that's true. However, if you'

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread pichi
Frank, Thanks for answering my post. I appreciate it very much. The reason I am not using BSCAN is in the documentation it says: "If you find yourself using this program, you have probably done something wrong." That kind of made me not want to use it but I will definately give it a try. I wil

Re: [Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread Frank Sweetser
pichi wrote: > Hello to all, > > I am new to Bacula and LINUX in general. I have read the documentation and > most of it makes sense to me. I am trying to roll out a production install > of Bacula for a small shop (20 machines in all). But I wanted to experiment > with Bacula before putting it to

[Bacula-users] Trying to restore catalog/mysql database

2007-08-24 Thread pichi
Hello to all, I am new to Bacula and LINUX in general. I have read the documentation and most of it makes sense to me. I am trying to roll out a production install of Bacula for a small shop (20 machines in all). But I wanted to experiment with Bacula before putting it to real work. We are going