Re: [Bacula-users] How to properly delete Clients and data from DB
2012-05-07 09:29:48
On Monday 07 May 2012 14:13:48 Martin Reissner wrote:
> Hello,
>
> I had to remove several clients (fds) from my bacula setup and I found
> no intructions on how to do this properly. Can someone please help me out?
> What I want to achieve is that all database entries related to those
> clients (clients, jobs, files,...) will be removed as this is quiet some
> data.
> My best guess was to delete those clients including
> jobs,filesets,schedules and also their dedicated storage devices and
> pools from the config files and then run dbcheck to remove orphaned
> entries but this didn't work as dbcheck reported no orphaned
> Clients/Jobs/.. but they are still in the DB when I check via SQL and
> the Clients are also still listed when prompted to select a Client in
> 'restore' mode.
>
> I'm using Bacula 5.0.2 with Mysql on Debian Squeeze 64.
>
> Regards,
>
> Martin
>
Whenever I remove a client I delete all it's configuration and run reload in
bconsole. Then remove the database entry manualy and run a dbcheck.
psql -c "delete from client where name='client-name'" bacula
dbcheck -f -b -c /etc/bacula/bacula-dir.conf
I use postgresql but the query should be the same for mysql.
Machiel.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|