>>>>> On Mon, 11 Feb 2013 09:51:55 -0500, Humphrey Bryant said: > > 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
The recommended way is using the delete pool command from bconsole. That also deletes the media records. __Martin > > 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 Stappers > >> Hey 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 > >> > >> Regards > >> > > Please bring it back to the bacula community, e.g. the mailinglist. > > > > ------------------------------------------------------------------------------ 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
