>>>>> 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
