On Sun, Dec 13, 2009 at 05:52:39PM +0000, Matthew Walster wrote:
> Hi there,
>
> I've inadvertently filled up /var with 100GB of Opsview databases. It
> turns out leaving "purge small/large tables" at zero for more than a
> year is a bad thing!
>
> The ibdata1 file is 70GB big, and I know I can't shrink that without a
> dump/restore, so I'll ignore that for now (the dump compressed down to
> 11GB, so I imagine it'll uncompress to a full disk again) and I can't
> delete any data because it says the filesystem is full.
>
> My thought is to drop the odw database (currently 35GB) and re-create it with
>
> /usr/local/nagios/bin/db_odw db_install
>
> Without any other amendments, is this likely to work? I'd set the
> upgrade.lock as per usual, to prevent imports.
>
> Any input welcome and appreciated - Opsview is currently working, but
> I don't want to leave it in the current situation!
It should work fine. I had to do something very similar the other day
after a power failure wrecked the odw database on my test system (cheers
mysql).
Stu
--
>From the prompt of Stu Teasdale
In our civilization, and under our republican form of government, intelligence
is so highly honored that it is rewarded by exemption from the cares of office.
-- Ambrose Bierce, "The Devil's Dictionary"
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
