On Thursday 03 May 2007 15:43, Mike Vasquez wrote:
> OK, how to I do a dump using sqlite?
>
> Mike
Look in the directory /etc/bacula/scripts. You should find a file named
make_catalog_backup. That'll do it.
cmr
> Darien Hager wrote:
> > Mike Vasquez wrote:
> >> What would be the best way to approach this? I have thought of just
> >> installing the latest version of Bacula in a different location and
> >> start with a fresh database. Then if someone wants to recover a file
> >> from an old
> >> backup, I could just use the older version of Bacula for this reason.
> >> Any
> >> opinions out there?
> >
> > I am most-definitely-not-a-guru about this question, but two ideas...
> > First, if Bacula doesn't do much that takes advantage of DB-specific
> > stuff (e.g. foreign key constraints, etc), you may be able to simply
> > recompile (if needed) the director with support for MySQL and do a dump
> > from SQLite into plain SQL and then run that against your MySQL server.
> >
> > Failing that, you could start a new fresh Director+MySQL set-up, use all
> > the old config scripts, and use "bscan" to scan the old volumes and put
> > their data into the database. (With a lot of tapes, this may take a
> > while... but if you were using SQLite, I'm guessing it was a fairly
> > light set-up to files?)
> >
> > --Darien Hager
> > [EMAIL PROTECTED]
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
--------
"More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
