Ferdinando Pasqualetti wrote (2006/05/22): > ... I could not read and reply to html mails well, but if you have MySQL and MyISAM, you do not need to drop the tables - it is sufficient to perform optimize table File; and all other tables (File, Path, Filename, ...) you want to shrink. Hopefully it would work for InnoDB too, or I believe there should be some other way to shrink tables without dropping them and rebuilding the db again. Similarly there is a command vacuumdb in PgSQL.
-- Rudolf Cejka <cejkar at fit.vutbr.cz> http://www.fit.vutbr.cz/~cejkar Brno University of Technology, Faculty of Information Technology Bozetechova 2, 612 66 Brno, Czech Republic ------------------------------------------------------- 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
