Hello,
Florian Daniel Otel schrieb:
Hello all,
I have a short question: Is there any documentation (formal or
otherwise) describing the SQL databases structre (table structure,
usage, etc.) used by the MySQL backend ? The only help in that respect
is the "query.sql" file that gives some hints on how things are looked
up in the bacula database. Not much else though...
The developers manual might have more information.
Also, a related question: How stable is that structure i.e. are there
any current/planned changes to that database ?
Usually, that structure is rather stable. As far as I know, Kern only
intends to change it when the major version of Bacula increases, e.g.
1.36->1.37/1.38. (Note the use of 'intends' and not 'allows'...) He
usually provides the necessary upgrade scripts.
There are no plans for modifying the catalog schema, as far as I know.
You will notice that there are many fields, columns or whatever you call
them, in there that are not yet used but rather are meant for future
implementation.
When reading the Projects fle, you will also find that there are some
planned enhancements which will require further catalog changes.
Or, in short: If you want to implement some functionality which needs
the catalog in a certain form you should discuss this on the developers
list.
On the other hand, a report script I wrote works, as far as I know,
correctly with the current and the last catalog version, and it works
with PostgreSQL and MySQL. This indicates that the 'vital' part of the
catalog is quite stable, I think.
Arno
TIA,
Florian
P.S. Wrt different SQL backends I didn't checked if there are any
differences btw. MySQL and e.g. PostgreSQL (I guess not). My question
pertained to MySQL since that I am currently deploying.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
