Re: [Bacula-users] Bacula database is getting too long

[CODE]
root@servername:/etc/init.d# du -sh /var/lib/mysql/bacula/
814M /var/lib/mysql/bacula/
[/CODE]

I just reset MySQL root password but can't really see user bacula's db password in bacula-dir.conf as it appears to be encrypted.

I just followed the instruction found here: http://www.bacula.org/en/dev-manual/main/main/Catalog_Maintenance.html and ran the following commands:

[QUOTE]
mysqldump -f --opt bacula > bacula.sql
mysql bacula < bacula.sql
rm -f bacula.sql
[/QUOTE]

But when I checked the size of the database it's still really large:

[QUOTE]
root@servername:/var/lib# cd bacula
root@servername:/var/lib/bacula# ls -l
-rw------- 1 bacula bacula 208285783 2012-01-10 05:23 bacula.sql
[/QUOTE]

Maybe I didn't do this correctly?

Please help,

Thank you in advance

> From: bwalton AT artsci.utoronto DOT ca
> To: bacula-users AT lists.sourceforge DOT net
> Date: Wed, 11 Jan 2012 13:19:07 -0500
> Subject: Re: [Bacula-users] Bacula database is getting too long
>
> Excerpts from Honia A's message of Wed Jan 11 13:11:45 -0500 2012:
>
> > I have been handed this server by the previous IT guy and don't have
> > the info required to access the MySQL database.
>
> The mysql password for the account bacula uses should be available to
> you in the Catalog stanza of the bacula-dir.conf file (or another file
> that it includes). Search for dbpassword.
>
> If you don't have the root password to your mysql instance, you can
> reset that by following something like:
> http://www.cyberciti.biz/tips/recover-mysql-root-password.html
>
> Thanks
> -Ben
> --
> Ben Walton
> Systems Programmer - CHASS
> University of Toronto
> C:416.407.5610 | W:416.978.4302
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual 
desktops for less than the cost of PCs and save 60% on VDI infrastructure 
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users