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