Hi Richard,
I would make a move instead of a delete so I keep the data, and dump the
mysql schema.
To reset bacula, I just need to drop the database and recreate the
schema ? (and change the data location to my NAS)
Thanks for the advice, I'll try this this weekend... I've my file system
filled up to 96% but still have 33GB left... ;)
I'll even try to truly restore the backup, to test the restore ;)
Regards,
Thomas.
On Thu, Aug 6, 2009 at 18:11, Richard Mortimer <ri...@oldelvet.org.uk>wrote:
>
>
> 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 <ri...@oldelvet.org.uk<mailto:
>> ri...@oldelvet.org.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.mansontho...@gmail.com <mailto:dev.mansontho...@gmail.com>
>> <mailto:dev.mansontho...@gmail.com
>> <mailto:dev.mansontho...@gmail.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
