<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <!--Converted with LaTeX2HTML 2008 (1.71) original version by: Nikos Drakos, CBLU, University of Leeds * revised and updated by: Marcus Hennecke, Ross Moore, Herb Swan * with significant contributions from: Jens Lippmann, Marek Rouchal, Martin Wilck and others --> <HTML> <HEAD> <TITLE>The internal database is not supported, please do not use it.</TITLE> <META NAME="description" CONTENT="The internal database is not supported, please do not use it."> <META NAME="keywords" CONTENT="misc"> <META NAME="resource-type" CONTENT="document"> <META NAME="distribution" CONTENT="global"> <META NAME="Generator" CONTENT="LaTeX2HTML v2008"> <META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css"> <LINK REL="STYLESHEET" HREF="misc.css"> <LINK REL="next" HREF="Bacula_Copyright_Trademark_.html"> <LINK REL="previous" HREF="Bacula_Projects.html"> <LINK REL="up" HREF="Bacula_Miscellaneous_Guide.html"> <LINK REL="next" HREF="Bacula_Copyright_Trademark_.html"> </HEAD> <BODY > <!--Navigation Panel--> <A NAME="tex2html255" HREF="Bacula_Copyright_Trademark_.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> <A NAME="tex2html249" HREF="Bacula_Miscellaneous_Guide.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> <A NAME="tex2html243" HREF="Bacula_Projects.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> <A NAME="tex2html251" HREF="Contents.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> <A NAME="tex2html253" HREF="Index.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> <BR> <B> Next:</B> <A NAME="tex2html256" HREF="Bacula_Copyright_Trademark_.html">Bacula Copyright, Trademark, and</A> <B> Up:</B> <A NAME="tex2html250" HREF="Bacula_Miscellaneous_Guide.html">Bacula Miscellaneous Guide</A> <B> Previous:</B> <A NAME="tex2html244" HREF="Bacula_Projects.html">Bacula Projects</A> <B> <A NAME="tex2html252" HREF="Contents.html">Contents</A></B> <B> <A NAME="tex2html254" HREF="Index.html">Index</A></B> <BR> <BR> <!--End of Navigation Panel--> <!--Table of Child-Links--> <A NAME="CHILD_LINKS"><STRONG>Subsections</STRONG></A> <UL> <LI><A NAME="tex2html257" HREF="internal_database_is_not.html#SECTION00710000000000000000">Internal Bacula Database</A> </UL> <!--End of Table of Child-Links--> <HR> <H1><A NAME="SECTION00700000000000000000"></A> <A NAME="InternalDbChapter"></A> <BR> The internal database is not supported, please do not use it. </H1> <A NAME="1217"></A> <A NAME="1218"></A> <P> <H1><A NAME="SECTION00710000000000000000"> Internal Bacula Database</A> </H1> <A NAME="1220"></A> <A NAME="1221"></A> <P> Previously it was intended to be used primarily by Bacula developers for testing; although SQLite is also a good choice for this. We do not recommend its use in general. <P> This database is simplistic in that it consists entirely of Bacula's internal structures appended sequentially to a file. Consequently, it is in most cases inappropriate for sites with many clients or systems with large numbers of files, or long-term production environments. <P> Below, you will find a table comparing the features available with SQLite and MySQL and with the internal Bacula database. At the current time, you cannot dynamically switch from one to the other, but must rebuild the Bacula source code. If you wish to experiment with both, it is possible to build both versions of Bacula and install them into separate directories. <P> <TABLE CELLPADDING=3 BORDER="1"> <TR><TD ALIGN="CENTER" COLSPAN=1><B>Feature </B></TD> <TD ALIGN="CENTER" COLSPAN=1><B>SQLite or MySQL </B></TD> <TD ALIGN="CENTER" COLSPAN=1><B>Bacula </B></TD> </TR> <TR><TD ALIGN="LEFT">Job Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Media Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">FileName Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">No</TD> </TR> <TR><TD ALIGN="LEFT">File Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">No</TD> </TR> <TR><TD ALIGN="LEFT">FileSet Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Pool Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Client Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">JobMedia Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">List Job Records</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">List Media Records</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">List Pool Records</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">List JobMedia Records</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Delete Pool Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Delete Media Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Update Pool Record</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">Yes</TD> </TR> <TR><TD ALIGN="LEFT">Implement Verify</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">No</TD> </TR> <TR><TD ALIGN="LEFT">MD5 Signatures</TD> <TD ALIGN="LEFT">Yes</TD> <TD ALIGN="LEFT">No</TD> </TR> </TABLE> <P> In addition, since there is no SQL available, the Console commands: <B>sqlquery</B>, <B>query</B>, <B>retention</B>, and any other command that directly uses SQL are not available with the Internal database. <P> <HR> <!--Navigation Panel--> <A NAME="tex2html255" HREF="Bacula_Copyright_Trademark_.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> <A NAME="tex2html249" HREF="Bacula_Miscellaneous_Guide.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> <A NAME="tex2html243" HREF="Bacula_Projects.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> <A NAME="tex2html251" HREF="Contents.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> <A NAME="tex2html253" HREF="Index.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> <BR> <B> Next:</B> <A NAME="tex2html256" HREF="Bacula_Copyright_Trademark_.html">Bacula Copyright, Trademark, and</A> <B> Up:</B> <A NAME="tex2html250" HREF="Bacula_Miscellaneous_Guide.html">Bacula Miscellaneous Guide</A> <B> Previous:</B> <A NAME="tex2html244" HREF="Bacula_Projects.html">Bacula Projects</A> <B> <A NAME="tex2html252" HREF="Contents.html">Contents</A></B> <B> <A NAME="tex2html254" HREF="Index.html">Index</A></B> <!--End of Navigation Panel--> <ADDRESS> 2010-06-14 </ADDRESS> </BODY> </HTML>