Bacula-users

[Bacula-users] Can't restore a file. Might have an issue with my mysql DB.

2010-02-23 16:17:57
Subject: [Bacula-users] Can't restore a file. Might have an issue with my mysql DB.
From: jch2os <bacula-forum AT backupcentral DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Tue, 23 Feb 2010 08:05:12 -0500
So I'm trying to restore a file.  Here is what I'm doing.

bconsole
restore
select number 6 (Select backup for a client before a specified time)

To select the JobIds, you have the following choices:
     1: List last 20 Jobs run
     2: List Jobs where a given File is saved
     3: Enter list of comma separated JobIds to select
     4: Enter SQL list command
     5: Select the most recent backup for a client
     6: Select backup for a client before a specified time
     7: Enter a list of files to restore
     8: Enter a list of files to restore before a specified time
     9: Cancel
Select item:  (1-9): 6
The restored files will the most current backup
BEFORE the date you specify below.

Enter date as YYYY-MM-DD HH:MM:SS :2010-01-01 00:00:00

** So I wanted the file before the first of this year **

Selected the server (Number 3, PDC) and I get this

Select the Client (1-6): 3
Automatically selected FileSet: PDC
+-------+-------+----------+---------------------+---------------+-----------+--------------+----------------+
| JobId | Level | JobFiles | StartTime           | VolumeName    | StartFile | 
VolSessionId | VolSessionTime |
+-------+-------+----------+---------------------+---------------+-----------+--------------+----------------+
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         8 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         7 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         8 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         7 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         7 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         7 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         6 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         6 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         6 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         6 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         6 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         5 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         5 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         5 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         5 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         4 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         4 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         8 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         4 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         4 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         3 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         3 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         3 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         3 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         3 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         2 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         2 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         2 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         2 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         1 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         1 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         1 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         1 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         0 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         0 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         0 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         0 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         0 |  
         73 |  1,258,746,653 |
| 5,108 | F     |  168,708 | 2009-12-01 03:38:11 | PDC-full-0004 |         8 |  
         73 |  1,258,746,653 |
| 5,255 | I     |    1,911 | 2009-12-22 02:31:18 | PDC-inc-0034  |         0 |  
        136 |  1,259,822,110 |
| 5,262 | I     |    1,254 | 2009-12-23 02:31:20 | PDC-inc-0036  |         0 |  
        143 |  1,259,822,110 |
| 5,269 | I     |    1,940 | 2009-12-24 02:31:21 | PDC-inc-0037  |         0 |  
        150 |  1,259,822,110 |
| 5,276 | I     |    1,100 | 2009-12-25 02:28:54 | PDC-inc-0038  |         0 |  
        157 |  1,259,822,110 |
| 5,283 | I     |       75 | 2009-12-26 02:05:22 | PDC-inc-0035  |         0 |  
        164 |  1,259,822,110 |
| 5,290 | I     |      163 | 2009-12-27 02:08:54 | PDC-inc-0039  |         0 |  
        171 |  1,259,822,110 |
| 5,297 | I     |      120 | 2009-12-28 02:05:23 | PDC-inc-0040  |         0 |  
        178 |  1,259,822,110 |
| 5,304 | I     |      922 | 2009-12-29 02:29:01 | PDC-inc-0041  |         0 |  
        185 |  1,259,822,110 |
| 5,311 | I     |    1,408 | 2009-12-30 02:34:31 | PDC-inc-0042  |         0 |  
        192 |  1,259,822,110 |
| 5,318 | I     |      988 | 2009-12-31 02:29:13 | PDC-inc-0043  |         0 |  
        199 |  1,259,822,110 |
+-------+-------+----------+---------------------+---------------+-----------+--------------+----------------+
You have selected the following JobIds: 
5108,5255,5262,5269,5276,5283,5290,5297,5304,5311,5318

Building directory tree for JobId 5108 ...
Building directory tree for JobId 5255 ...
Building directory tree for JobId 5262 ...
Building directory tree for JobId 5269 ...
Building directory tree for JobId 5276 ...
Building directory tree for JobId 5283 ...
Building directory tree for JobId 5290 ...
Building directory tree for JobId 5297 ...
Building directory tree for JobId 5304 ...
Building directory tree for JobId 5311 ...
Building directory tree for JobId 5318 ...
11 Jobs, 0 files inserted into the tree.

You are now entering file selection mode where you add (mark) and
remove (unmark) files to be restored. No files are initially added, unless
you used the "all" keyword on the command line.
Enter "done" to leave this mode.

cwd is: /
$

0 Files????

I look at the actual files and they aren't 0bytes so I think there is stuff in 
there.  I tried using bextract but since these files were on a windows machine 
it doesn't work.  Can someone point me in the right direction?

Thank you for your help!

+----------------------------------------------------------------------
|This was sent by jwaters AT fisherthompson DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------



------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users