ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Backing up tests and their associated results



  • 2004-11-05 11:12:41

    Backing up tests and their associated results

    ATutor 1.4.2 using a commercially hosted MySQL server.

    One area within ATutor which is not easily to backup is the students' submitted tests. As we're using a hosted server, I either have to use PhpMyAdmin to dump the appropriate tables or look at writing a script to automate the process for me. I'm currently leaning towards the latter.

    However, before I go out and try to possibly re-invent the wheel, I wondered if anyone else had come up with a method of regularly backing up tables on a hosted server?

    If I do have to resort to dumping tables via a script, what tables should I aim for. All of the _test tables?

    All suggestions welcome :)

    Mel


  • 2004-11-05 13:06:14

    New test system in the works

    There was a CSV dump of text results available in earlier versions that had to be disabled temporarily for the current release. The testing system is being rebuilt. We hope to have the test result dump feature backin in the next release. For now you could display the test results and copy and paste the display

    You can currently backup the tests and questions themselves using a course backup.


  • 2004-11-05 15:10:15

    Looking for something more global

    I am making regular backups of course content and test questions as/when courses are amended. The issue is really just the student test results.

    At present, we hope to encourage students to make copies of their own test results using the copy and paste method but I wouldn't like to rely on this. With approximately 40 separate tests across 6 courses, copy 'n' paste isn't really a practical option for a course admin with very limited time.

    A dump script that can be run once or twice a week still appears to be the most practical option.

    [reply][b]In reply to:[/b]
    There was a CSV dump of text results available in earlier versions that had to be disabled temporarily for the current release. The testing system is being rebuilt. We hope to have the test result dum...
    [op]forums/view.php?fid=7;pid=2982;page=1#2983[/op][/reply]


  • 2004-11-05 16:25:07

    Dump is still there

    The dump scripts are still in the source code, though they need to be updated to match the new db structure. We did not have time to update the scripts before the last release, so they were just commented out. You will find them in tools/test/.. identified with csv in the filename, if you want to modify them to work with the new db structure. There will be a little effort involved, so you may want to wait for the New Year release.

    Things are going to change again for the next release, so any modifications to the files will become obsolete, but we will be creating new scripts so you can dump test data from the new testing system.


  • 2004-11-05 16:52:52

    Thanks

    I'll have a look at those scripts. I may be able to use them to solve my problem short term.

    Thanks for the heads up, greg.