-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bill Moran wrote: > In response to Dominik Jonas <[EMAIL PROTECTED]>: >> our HDD has 8,4 GB and now it is full because the database file is at >> the moment 7,8 GB >> >> -rw-rw---- 1 mysql mysql 7.8G Feb 1 10:14 ibdata1 >> >> on the device is the sql dum with 577 MB, too. >> >> My question is now how to make the file ibdata1 smaller, delete old >> entries in the db or i dont know. >> >> How can I do this? > > Research the purge command available through bconsole.
Also try running Bacula's dbcheck command once in a while to check for orphaned records and clean those. dbcheck /path/to/bacula/working/dir (enable the 'modify' flag to actually perform changes to the db) In addition to that, to actually bring down the size of the MySQL files, you have to run OPTIMIZE over the respective tables. For example: mysqlcheck -o --all-databases -u mysqladmin -p (check MySQL documentation for details) Greetings, Michel -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) - GPGrelay v0.959 iD8DBQFFwfPc2Vs+MkscAyURAjLZAKCBGNX7AfZKXswLszhboILLmop1GgCdFJ9m sC+Q0V0jXrwI7apqRtNqR6A= =tDxZ -----END PGP SIGNATURE----- ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users