Forum LAMS for Tech-Heads - General Forum: sql exportd


 
You may request notification for sql exportd .
Search: 

1: sql exportd
11/09/10 03:14 AM
[ Reply | Forward ]
dear managers;
I have a question.in lams Is there a way to courseware (zip) exported into sql(data), and then use the sql into the database;then,sql is the courseware data;?

Posted by anyu fu

2: Re: sql exportd
In response to 1 11/09/10 05:34 AM
[ Reply | Forward ]
Hi Anyu,

I'm not so sure what you mean by courseware. Do you mean backup a course or the entire LAMS server data?

If so, have a look at these backup instructions:

http://wiki.lamsfoundation.org/display/lamsdocs/Revert+To+Other+Backup

Thanks

Ernie

Posted by Ernie Ghiglione

3: Re: Re: sql exportd
In response to 2 11/09/10 07:05 PM
[ Reply | Forward ]
no. courseware mean the lams_learning_design;
I want to make data of a lams_learning_design into sql but no zip;

Posted by anyu fu

4: Re: Re: Re: sql exportd
In response to 3 11/10/10 04:53 AM
[ Reply | Forward ]
Ah! I see what you saying now...

I guess you could find all the related tables and do a single sql scripts that gets all the related records for a particular learning design. BUT, this won't export any files uploaded into the learning design. So you might only get half of the content. See here for some of the data model relationships though http://is.gd/gTHsh

The big advantage of the zip file is that it contains both. If you want just the data structure, parse the .xml files in the zip and that will give you the data and relations between the design and its activities. Additionally it gives you the files uploaded by the teacher (images, videos, documents, etc).

I hope that helps,

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum