[Dspace-general] Migrating data from MySQL

[Sam Ottenhoff]

Hi Walker,

There are several ways to accomplish your goal, but the most 
straightforward method will probably be writing a script that connects 
to your MySQL database, creates a folder for each item, converts your 
metadata to qualified Dublin Core elements, writes the metadata to disk 
in the format DSpace expects (dublin_core.xml), places the file 
object(s) in the folder, and finally, writes a "contents" file 
containing the names of the file object(s).  Once you have a folder for 
each item in the format DSpace expects, you will be able to import all 
of the items with one command (bin/import).

The next step will be to understand the DSpace import/export XML file.  
I would start by exporting some items currently in your DSpace instance 
(see section 9.5.3 of the DSpace 1.5.2 manual).  From the export, you 
will see the structure DSpace expects and will see the details of the 
dublin_core.xml file.

--Sam

Walker Sampson wrote:
> Hi all,
>
> Apologies in advance if this has already been covered.
>
> I have a lot of records stored in a MySQL database. I've just got an
> instance of DSpace up, and I'd like to migrate the records from MySQL
> to a collection in DSpace. Has anyone done something similar to this
> or know what some first steps would be?
>
> Thank you,
> Walker
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>