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 <ri...@oldelvet.org.uk > <mailto: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> > <mailto: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>> > <mailto: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