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

Back to LAMS for Tech-Heads - General Forum
	Search:

	2: Re: sql exportd By: Ernie Ghiglione	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 By: anyu fu	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 By: Ernie Ghiglione	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