Timo Neuvonen wrote:
> I guess this is more a database issue than a bacula issue, but anyway:
>
> What is the proper way to restore the bacula catalog to mysql server, when I
> have available the database dump file (bacula.sql) made by
> make_catalog_backup script.
>
> So, this has nothing to do with finding the catalog data from a tape drive
> etc. What I'm actually trying to do, is to learn a foolproof way to restore
> the catalog to is current state after some "trial and error"- style
> experiments with bacula.
>
>
> On a system with no bacula installed, I tried this (syntax copied from a
> restore example in the catalog backup script):
>
> mysql <bacula.sql
>
> which results in an error message:
>
> ERROR 1046 (3D000) at line 22: No database selected
>
> So it obviously won't be this simple?
Almost that simple:
mysql
create database bacula
use bacula
\. bacula.sql
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
