Bacula-users

Re: [Bacula-users] disk full, need to reset and upgrade

2009-08-07 13:48:51
Subject: Re: [Bacula-users] disk full, need to reset and upgrade
From: Richard Mortimer <richm AT oldelvet.org DOT uk>
To: Thomas Manson <dev.mansonthomas AT gmail DOT com>
Date: Fri, 07 Aug 2009 18:42:59 +0100

Thomas Manson wrote:
> 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)
> 
Yes. But you are best advised to stop the bacula director before doing this.

Regards

Richard

>   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 <richm AT oldelvet.org DOT uk 
> <mailto:richm AT oldelvet.org DOT 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
>         <richm AT oldelvet.org DOT uk <mailto:richm AT oldelvet.org DOT uk>
>         <mailto: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>>
>                <mailto: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