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.