>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 then run the
bacula.sql
>script with:
>\. bacula.sql
OK here is what I did:
I was able to import the bacula.sql file into the newly built mysql database
with this command:
bacula:/tmp/bacula-restores/var/lib/bacula# mysql -u bacula1 -p bacula2
<bacula.sql
Where bacula1 is the name of the user for the import and bacula2 is the name
of the Database.
After I did this suddenly I had all my jobIDs to choose from in bconsole. So
without doing anything else in bconsole i did:
restore
Using default Catalog name=MyCatalog DB=bacula
First you select one or more JobIds that contain files
to be restored. You will be presented several methods
of specifying the JobIds. Then you will be allowed to
select which files from those JobIds are to be restored
To select the JobIds, you have the following choices:
3: Enter list of comma separated JobIds to select
Select item: (1-12): 3
+-------+-----------+---------------------+----------+----------+-------------+
| JobId | Client | StartTime | JobLevel | JobFiles | JobBytes
|
+-------+-----------+---------------------+----------+----------+-------------+
| 32 | kaka | 2007-08-23 23:05:03 | I | 23 | 20259340
|
| 31 | kaka | 2007-08-23 14:30:43 | I | 23 | 20068169
|
| 30 | bacula-fd | 2007-08-23 14:30:05 | F | 1 | 2757697
|
| 29 | bacula-fd | 2007-08-23 14:25:52 | F | 1 | 2757324
|
| 27 | kaka | 2007-08-23 14:00:34 | I | 7 | 164890
|
| 26 | kaka | 2007-08-23 12:53:11 | I | 0 | 0
|
| 25 | kaka | 2007-08-23 12:52:33 | I | 9 | 14663097
|
| 23 | kaka | 2007-08-23 12:13:45 | I | 119 | 22307348
|
| 6 | kaka | 2007-08-22 23:05:03 | I | 70 | 22611512
|
| 5 | kaka | 2007-08-22 14:36:55 | F | 11525 | 924939955
|
| 4 | kaka | 2007-08-22 13:48:59 | I | 423 | 46504847
|
| 2 | kaka | 2007-08-21 09:11:55 | F | 11277 | 901038239
|
+-------+-----------+---------------------+----------+----------+-------------+
Enter JobId(s), comma separated, to restore: 5
You have selected the following JobId: 5
Building directory tree for JobId 5 ...
++++++++++++++++++++++++++++++++++++++++++++++++
1 Job, 11,174 files inserted into the tree.
I marked the file I wanted and then got this:
Defined Clients:
1: bacula-fd
2: kaka
Select the Client (1-2): 2
Run Restore job
JobName: RestoreFiles
Bootstrap: /var/lib/bacula/bacula-dir.1.restore.bsr
Where: /tmp/bacula-restores
Replace: always
FileSet: Full Set
Client: kaka
Storage: AIT2
When: 2007-08-24 14:18:39
Catalog: MyCatalog
Priority: 10
OK to run? (yes/mod/no): y
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 missing
something??
Thanks again,
Pete
--
View this message in context:
http://www.nabble.com/Trying-to-restore-catalog-mysql-database-tf4322917.html#a12312627
Sent from the Bacula - Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
