Moodle - how do you flush a table? And CPD
We use moodle 1.9 on a windows server 2008. We use my SQL administrator to manage the tables.
Our statistics table has gotten too big so when it is enabled on a page it takes 30 seconds to load the page. I want to flush the table to start off with an empty table. Does anyone have a good step by step on how I can do this?
Secondly does anyone know of any good moodle administrator courses? Not a course for creating courses but one that helps manage a moodle install. Good maintenance tasks, problem solving etc? Preferably in the north west?
Or does anyone know of any good checklists for moodle maintenance tasks? Like annual tasks to keep moodle running quickly.