I've dropped the entire Bacula mysql database and re-created it and my Bacula seems to be working and it's free'd up about 10GB's of space now, however I do still have a very large /var/spool/bacula/bacula.sql (12GB) and log.sql (2GB) any ideas how I prune or re-create these?
I'm quite sure these are backup files (dump of your database). If this is true, you can just delete it. Normally, when doing the Catalog backup, we run the make_catalog_backup (runbeforejob directive) and then delete_catalog_backup (runafterjob directive). This way we just keep the .sql dump in the backup volume file, not in filesystem.
Also as you have an almost empty catalog database, your .sql dump will not be so large. But it is a good idea to estimate how long it would increase and let free space in your filesystem for this.
If you do not have any jobs/volumes/files from the old Catalog to keep in this new one installation (I´m supposing you lost all your backup data), you can start with an empty Catalog database an your old conf files. All the clients, jobs/filsets, schedules, etc., information are on your configuration files and will be used in your new installation.
Please could someone assist me. I'm very new to Bacula and urgently need to get previously working backups running again. I didn't install Bacula nor do I know much about it and I currently have two issues that I need help with if possible please...
To give you some background details first...
CentOS release 6.3 (Final)
bacula-director-mysql-5.0.0-12.el6.x86_64
bacula-client-5.0.0-12.el6.x86_64
bacula-storage-common-5.0.0-12.el6.x86_64
bacula-console-5.0.0-12.el6.x86_64
bacula-docs-5.0.0-12.el6.x86_64
bacula-common-5.0.0-12.el6.x86_64
bacula-director-common-5.0.0-12.el6.x86_64
bacula-traymonitor-5.0.0-12.el6.x86_64
bacula-console-bat-5.0.0-12.el6.x86_64
bacula-storage-mysql-5.0.0-12.el6.x86_64
mysql-5.1.61-4.el6.x86_64
Webmin is used to admin the Bacula and backups.
The existing NAS which was mounted locally via NFS died, so we've lost all backup data, and we've implemented a new empty NAS and mounted it locally again via NFS in the same Storage destination as before /mnt/nas/bacula
1.) How do I go about removing all previous records of backups out of Bacula and get new clean first time backups to run?
There's currently a mismatch between what Bacula says it has in terms of backups and what shows on the local NFS filesystem presumably because the MySQL DB's still have the old records.
2.) My backup guest that has Bacula installed on it is dangerously short of space (200MB free) and /var/spool/bacula/ is taking up most of the space 12GB and then then /var/lib/mysql/bacula/Log.MYD (10GB) is also a culprit. I presume this is all old catalog data/records that's stored in the above mysql databases, how can I go about delete/cleaning this up without losing my Backup Clients, or will question one above solve both issues?
Apologies for sounding very vague on the above, unfortunately this is all extremely new to me and I've battled finding documentation on the above problems so far, but I urgently need to get backups working.