Re: [Koha-devel] Cleaning up...

At 01:10 PM 9/11/2015 -0400, Mark Tompsett wrote: Greetings, > I would suggest the cleanup_database.pl script in the cronjobs directory, except I've just looked at it and it doesn't touch the import_items or import_biblios tables. As Galen mentioned it does via cas

Re: [Koha-devel] Cleaning up...

Yeah, I didn't think to check the foreign key rules. Thanks for correcting me on that :) On Fri, Sep 11, 2015 at 11:10 AM, Mark Tompsett wrote: > Greetings, > > > > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the

Re: [Koha-devel] Cleaning up...

Greetings, > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the import_items or > import_biblios tables. As Galen mentioned it does via cascades. Thanks for pointing me at the better way. GPML, Mark Tompsett __

Re: [Koha-devel] Cleaning up...

Hi, On Fri, Sep 11, 2015 at 1:02 PM, Michael Hafen wrote: > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the import_items or > import_biblios tables. > Actually, it does, via the --import DAYS switch and cascading

Re: [Koha-devel] Cleaning up...

I would suggest the cleanup_database.pl script in the cronjobs directory, except I've just looked at it and it doesn't touch the import_items or import_biblios tables. On Fri, Sep 11, 2015 at 8:22 AM, Mark Tompsett wrote: > Greetings, > > mysql> SELECT table_name, table_rows, round(((data_length

[Koha-devel] Cleaning up...

Greetings, mysql> SELECT table_name, table_rows, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES where table_schema = "koha_library" and ((data_length+index_length)/1024/1024)>10 order by (data_length+index_length); +-+--