Christoph Litauer wrote:
> Most often I need to restore whole directories (recursive) out of the
> last backup or using a backup some time ago. Because there is no bacula
> command for restores of directories, I use the interactive restore method.
> When selecting a job that contains about 10 Mio. files, building the
> directory tree lasts about 30 minutes -- which is very long.

Add more memory.. I'll bet your system is swapping out while building
the tree.

> So I have a few questions:
> 1.) Any hints how to recover a directory recursive without using
> interactive mode?

It's something like this:
http://krogh.cc/~jesper/bacula-restore.txt

> 2.) Any hints concering mysql optimizations for a bacula database as big
> as mine?

Add more memory.

> 3.) What are your directory building times when using interactive restores?

For 8.5 million files ~ 2 minutes.

-- 
Jesper

------------------------------------------------------------------------------
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