[Dspace-general] Migrating data from MySQL

[Walker Sampson]

Sam, thanks for the PHP script. I'll see what I can do with it to let
it work with MySQL instead.

This project is a bit down the line but it doesn't hurt to plan. I'll
let you all know what the solution ends up being!

-Walker


On Tue, Aug 4, 2009 at 4:12 PM, Walker Sampson<walker.sampson at gmail.com> wrote:
> 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
>



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