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. You can also set up automatic purging to occur when data reaches a certain age. Now that you know how much data you can store before your drive fills up, you should be able to estimate a reasonable length of time to save it for. -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- 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
