[Dspace-general] Migrating data from MySQL

[Walker Sampson]

Hey guys,

Thanks for the info, this has been extremely helpful! Here are a few
more details:

The MySQL database was used with a PHP front-end and was not part of a
DSpace installation. It contains simple textual metadata for each
record; these are not Dublin Core elements. The MySQL database doesn't
store any bitstreams. There are about 1500+ records in the MySQL
database.

Regarding writing a script to write the records in a Dublin Core XML
file, is there a scripting language you suggest? We're running a
CentOS 5 server here.

Thanks again!

On Tue, Aug 4, 2009 at 2:52 PM, Jeffrey Trimble<jatrimble at ysu.edu> wrote:
> Walker,
> Well, that depends.  You could map out an extraction file to the PostgreSQL,
> but
> I guess the bigger question is what purposes was the MySQL used for?  Was it
> a prior
> DSpace installation?  (That would make the process somewhat easier).
> Are these records in MySQL storing Dublin Core Metadata + the bitstream?
> In a future release there will be a batch editing program that **might** (I
> use caution here)
> assist you with the data.  Also, there is an excel macro tool that OhioLINK
> uses
> to load records and their associated Metadata into DSpace.
> I think you question needs a little more detail before a solid answer could
> be given to you.
> Best wishes,
> Jeffrey Trimble
> System LIbrarian
> William F.  Maag Library
> Youngstown State University
> 330.941.2483 (Office)
> jtrimble at cc.ysu.edu
> http://www.maag.ysu.edu
> http://digital.maag.ysu.edu
> "I must not fear.  Fear is the mind-killer.
> I will permit it to pass over me and through me..."
> --Litany against fear....
> On Aug 4, 2009, at 3:28 PM, Walker Sampso Apple-interchange-newline">
>
> 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
>
>



-- 
Walker Sampson
MS in Information Studies, Expected 2010
School of Information, UT Austin
http://www.ischool.utexas.edu/~walker