Chris Howells wrote: > Are you running out of space on /tmp, the default location that MySQL > stores temporary tables (until they are copied into their final table)? > This can happen if you have a reasonably small / (which is pretty common).
No, I don't think this is the problem in my case. Mysql's tmpdir is /var/tmp, and has 34G free. > I have so far used bacula 2.2.5 to backup 15TB and about 100 million > files (10GB catalog) without a single batch table problem. I realize there are people who back up more than I do, and do it without a problem. But we all have different backup ecosystems, and *something* in mine is causing mysql to drop temporary tables. I see this in the binlog: #071207 15:13:04 DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `bacula`.`batch`/*!*/; So I'd really like to test bacula without the temporary tables feature, and was hoping for some advice on doing so within the limits of the FreeBSD port sysutils/bacula-server. Thanks, -- Dane Miller Systems Administartor Greatschools, Inc http://www.greatschools.net ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
