Thomas Manson wrote:
> Hi Richard,
> 
>   My current backup have loads of un necessary data...
> 
>   That's why I'd like to reset my bacula.
That makes sense. I suggested that you might copy the backup data as an
interim precaution to ensure that you were not without a backup of your 
data whilst making the changes. If you are comfortable just deleting the 
data (and removing it from the database too) then I will not argue 
against it.

> 
>   Also to re-work the exclude list I've setup and that doesn't work, I 
> need to know what file was backup during the last job.
> 
> How I do that ?
I see that no-one has jumped in with ideas yet and I must claim the my 
bacula setup has been fairly static for a while (why break something 
that works!) but my suggestion would be to use bconsole to setup a 
restore job. Once in the restore job you can move around the directory 
tree and look at what is in there. You don't need to complete the 
restore operation but you can look around.

If you have the jobId of the last backup handy (look in the email that 
bacula sends when a backup completes) the select option 3 (Enter list of 
comma separated JobIds to select) from the restore command and enter the 
jobId.

One you have selected the job bacula will drop you into the file 
selection mode where you can use the cd command to move around and ls to 
list things. If you use the mark command to mark a specific directory 
then you can use the estimate command to show you the total data 
selected in that directory. If you unmark those file then you can 
estimate other directories. It can be slow going if you have lots of 
folders to look at but it does work. Others may have better suggestions.

Below is an example from one of my incremental backups for a small host.

Regards

Richard

*restore

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:
      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: Find the JobIds of the most recent backup for a client
     10: Find the JobIds for a backup for a client before a specified time
     11: Enter a list of directories to restore for found JobIds
     12: Cancel
Select item:  (1-12): 3
Enter JobId(s), comma separated, to restore: 3791
You have selected the following JobId: 3791

Building directory tree for JobId 3791 ...
1 Job, 17 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: /
$ ls
var/
$ cd var
cwd is: /var/
$ ls
spool/
$ mark spool
17 files marked.
$ estimate
17 total files; 17 marked to be restored; 185,790,882 bytes.
$ unmark spool
17 files unmarked.
$ estimate
17 total files; 0 marked to be restored; 0 bytes.
$






> 
> I've tryed to browse the mysql database, but filename are in blob which 
> is not handy for browesing.
> 
> Thomas.
> 
> On Tue, Aug 4, 2009 at 10:47, Richard Mortimer <richm AT oldelvet.org DOT uk 
> <mailto:richm AT oldelvet.org DOT uk>> wrote:
> 
>     Hi Thomas,
> 
>     It isn't clear from your message what you are asking for help with.
>     That said I have made some comments inline below.
> 
>     Thomas Manson wrote:
> 
>         One other thing :
> 
>          I've set to 40 volumes.
>            When all volume were filled up, I was expecting bacula to
>         recycle the first volume... but it didn't, I had to increase the
>         number of volume...
> 
>         Thomas.
> 
>         On Tue, Aug 4, 2009 at 09:58, Thomas Manson
>         <dev.mansonthomas AT gmail DOT com <mailto:dev.mansonthomas AT gmail 
> DOT com>
>         <mailto:dev.mansonthomas AT gmail DOT com
>         <mailto:dev.mansonthomas AT gmail DOT com>>> wrote:
> 
>            Hi,
> 
>              I've been using bacula to backup remote hosts through ssh
>         connection.
> 
>              It works well except that :
> 
>                * a lot of data is backed up on remote host uselessly (as log
>                  file ...)
>                * I need to upgrade to bacula 3.x to have the exclude
>         feature...
>                  but I'm running on ubuntu and would like to keep the
>         apt-get
>                  update feature working for bacula
>                * My hardrives are full. While I didn't have a NAS ready,
>         I set
>                  the backup directory to /backup on my primary disks
>         (raid1).
>                  I now have 2.7TB in Raid5 on a nas mounted in /mnt/backup
> 
> 
>            What I would like is :
> 
>                * upgrade to v3 and backup only what is needed (with the
>         exclude
>                  feature)
> 
>     It isn't clear if Exclude is the only reason why you want to upgrade
>     to v3 but the Exclude directive in FileSet has been there for a long
>     time and it certainly exists in the 2.x series. There is no need to
>     upgrade to get that functionality.
> 
>                * delete all existing backup in /backup (150GB)
> 
>                * start backing up on /mnt/backup
> 
>     Why not just copy/move the data from /backup into /mnt/backup and
>     then change your -sd configuration to point to /mnt/backup. That way
>     you can keep all of your existing backups and get your setup
>     correctly configured without too much disruption.
> 
>     Before you copy the data you should ensure that no backups are
>     currently running and stop the -sd before moving the files. Once you
>     have moved the files edit you bacula-sd.conf to point to the new
>     location and restart the sd daemon.
> 
>     Regards
> 
>     Richard
> 
> 
> 
>            my filesystem is almost full (96%) ...
> 
>            Thanks for any help ;)
>            Thomas.
> 
> 

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users