No probs. but i found a "noob way" to get rid of the stale/old records.
I went to bconsole and run "list pools";after it gave me a list of Pools I then look on the *Pool Id *of the stale/old Pools then login to the (MYSQL) bacula database an deleted the respective pool id's from the *Pools table* inside the Bacula Database and that got rid of the stale records.
Thanks for your input nonetheless Cheers On 02/11/2013 04:40 AM, Geert Stappers wrote:
Op 20130207 om 18:55 schreef Humphrey Bryant:On 02/07/2013 03:03 AM, Geert Stappers wrote:Op 20130130 om 17:38 schreef Humphrey Bryant:Hi All, I am running Bacula 5.2.12 on CentOS 6.2 storing my backups to Disk (fileStorage). I recently removed some bacula clients that no longer exists on my network from my "bacual-dir.conf" file but whenever i go to Bconsole and try to do a restore /backup i notice i still see the (Old) Clients that I have deleted in there. None of these Old Clients have never run a backup before on bacula; they were created as typos (incorrect names) when setting up bacula hence i want to get rid of them to ease the confusion. Also I Removed/Purged some Volumes from bacula but when i go to Bconsole and run "list volumes" i still see the old volumes there even though i purged, volume delete and remove (rm -rf) the file from the server. These volumes still show up with no info attached to them. How can i remove these stale (Old) Client/Volume info from Bacula?AFAIK it is something along select ClientId, Name from Client order by ClientId ; delete from Client where Name = 'your_no_longer_existing_client' ; Yes, those are database actions. They can be performed from `bconsole` with the command `sqlquery`. Cheers Geert StappersHey thanks for your reply, I went into the MYSQL database via phpmyadmin and I see the client list but they don't show actual names but judging by the info I see in them i can identify the non-existent clients. I was wondering if i could just delete them from the database this way (via phpmyadmin)? This is what i see for client name in the MYSQL Tables [BLOB - 0 B] [BLOB - 12 B] I will read up on Bconsole 'sqlquery' and see how best I can remedy this problem. Thanks again for your reply RegardsPlease bring it back to the bacula community, e.g. the mailinglist.
<<attachment: hbryant.vcf>>
------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
