(Rob, I emailed Kevin already about this - did he not get it?)
Basically you need to FTP (or otherwise transfer) the file on to the Linux server, then use the Unix command line to run the mysqlimport command, eg:
mysqlimport -u youruser -p yourdatabase textfile.sql
Martin Dougiamas
Posts made by Martin Dougiamas
Moodle in English -> General help -> Using code in submissions -> Re: Using code in submissions
by Martin Dougiamas -
Do you mean switch a <code> tag on and off? Or switch all HTML on and off?
I'm also not sure what you mean by the applets (Moodle doesn't have any).
I'm also not sure what you mean by the applets (Moodle doesn't have any).
Moodle in English -> Testing and QA -> Improved performance on Recent Activity
by Martin Dougiamas -
I only recently noticed that users who had been away for a few weeks who were trying to get back in to this course (Using Moodle) were having the course page become very slow and sometimes never finish loading!
The problem was too much data to process when creating the Recent Activity display (lots of things happening in this course!) which overwhelmed the way I was doing it (it wasn't very scalable). I've just implemented a new method which appears to give roughly the same speed for small courses, but also gives decent performance on large courses too. Yay!
The problem was too much data to process when creating the Recent Activity display (lots of things happening in this course!) which overwhelmed the way I was doing it (it wasn't very scalable). I've just implemented a new method which appears to give roughly the same speed for small courses, but also gives decent performance on large courses too. Yay!
Moodle in English -> General developer forum -> Need to import a Blackboard question pool? Try this! -> Re: Need to import a Blackboard question pool? Try this!
by Martin Dougiamas -
Great! Thanks for the work! I'll give it a go ASAP, and yes, I'd love to add it to the options. License for xmlize is the widely-known Ye Ole "Feel Free To Use it However" License which is good.
A couple of quick answers ... yes, deleting a lot of questions is a pain currently ... I started on a 'delete selected' function but got caught up in all the issues of what to do with questions already implemented in a quiz etc which needs a whole GUI ... a shortcut I've been using to 'delete all' is to create a TRASH category, then delete the whole category moving the questions to TRASH.
And yes, I've also been thinking of separating out the question pool management, so data entry can occur without a quiz. Just a matter of time ...
A couple of quick answers ... yes, deleting a lot of questions is a pain currently ... I started on a 'delete selected' function but got caught up in all the issues of what to do with questions already implemented in a quiz etc which needs a whole GUI ... a shortcut I've been using to 'delete all' is to create a TRASH category, then delete the whole category moving the questions to TRASH.
And yes, I've also been thinking of separating out the question pool management, so data entry can occur without a quiz. Just a matter of time ...