Bacula-users

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

2010-02-23 16:35:54
Subject: Re: [Bacula-users] Can't restore a file. Might have an issue with my mysql DB.
From: charlieR <linuxassassin AT gmail DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Tue, 23 Feb 2010 15:33:34 -0600
Sorry replied off list.

You did do a 'ls' at that last prompt right? I didn't see that in your  
output. At that point right there it's like a mini shell that you have  
to traverse to view files that have been backed up.

Regards,

Charlie

On Feb 23, 2010, at 7:05 AM, jch2os wrote:

>
> 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


------------------------------------------------------------------------------
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

<Prev in Thread] Current Thread [Next in Thread>