1%%
2%%
3
4\chapter{The internal database is not supported, please do not
5use it.}
6\label{InternalDbChapter}
7\index[general]{Use it!The internal database is not supported please
8do not }
9\index[general]{The internal database is not supported, please do not
10use it. }
11
12\section{Internal Bacula Database}
13\index[general]{Internal Bacula Database }
14\index[general]{Database!Internal Bacula }
15
16Previously it was intended to be used primarily by Bacula developers for
17testing; although SQLite is also a good choice for this. We do not recommend
18its use in general.
19
20This database is simplistic in that it consists entirely of Bacula's internal
21structures appended sequentially to a file. Consequently, it is in most cases
22inappropriate for sites with many clients or systems with large numbers of
23files, or long-term production environments.
24
25Below, you will find a table comparing the features available with SQLite and
26MySQL and with the internal Bacula database. At the current time, you cannot
27dynamically switch from one to the other, but must rebuild the Bacula source
28code. If you wish to experiment with both, it is possible to build both
29versions of Bacula and install them into separate directories.
30
31\addcontentsline{lot}{table}{SQLite vs MySQL Database Comparison}
32\begin{longtable}{|l|l|l|}
33 \hline
34\multicolumn{1}{|c| }{\bf Feature } & \multicolumn{1}{c| }{\bf SQLite or MySQL
35 } & \multicolumn{1}{c| }{\bf Bacula  } \\
36 \hline
37{Job Record  } & {Yes  } & {Yes  } \\
38 \hline
39{Media Record  } & {Yes  } & {Yes  } \\
40 \hline
41{FileName Record  } & {Yes  } & {No  } \\
42 \hline
43{File Record  } & {Yes  } & {No  } \\
44 \hline
45{FileSet Record  } & {Yes  } & {Yes  } \\
46 \hline
47{Pool Record  } & {Yes  } & {Yes  } \\
48 \hline
49{Client Record  } & {Yes  } & {Yes  } \\
50 \hline
51{JobMedia Record  } & {Yes  } & {Yes  } \\
52 \hline
53{List Job Records  } & {Yes  } & {Yes  } \\
54 \hline
55{List Media Records  } & {Yes  } & {Yes  } \\
56 \hline
57{List Pool Records  } & {Yes  } & {Yes  } \\
58 \hline
59{List JobMedia Records } & {Yes  } & {Yes  } \\
60 \hline
61{Delete Pool Record  } & {Yes  } & {Yes  } \\
62 \hline
63{Delete Media Record  } & {Yes  } & {Yes  } \\
64 \hline
65{Update Pool Record  } & {Yes  } & {Yes  } \\
66 \hline
67{Implement Verify  } & {Yes  } & {No  } \\
68 \hline
69{MD5 Signatures  } & {Yes  } & {No }
70\\ \hline
71
72\end{longtable}
73
74In addition, since there is no SQL available, the Console commands: {\bf
75sqlquery}, {\bf query}, {\bf retention}, and any other command that directly
76uses SQL are not available with the Internal database.
77