Mason, On Sat, Jan 14, 2012 at 3:57 AM, Mason James <m...@kohaaloha.com> wrote: > > > Truncating should work fine, but I saw somewhere (I think in the e-mail > archives not positive), that it could take longer. I'm not sure that is > true or not since I didn't try it. The advantage to truncate though would > be I wouldn't have had to look up how to recreate the table. > >> just curious, why not just truncate the table? > > aaah, that Q was for Jared... :) > > but answering my own question, i guess its because for the default inno-db > config for mysql, a truncate wont delete the existing space for that table > - where as a drop/create will
That was my reasoning. It's possible that was unnecessary, but given that the problems all started when the system ran out of disk space, it seemed like a worthwhile precaution. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha