|Date||Tue, 30 Oct 2007 15:23:23 +1300|
|Subject||Re: [greenstone-users] (no subject) [Adding a database to greenstone]|
Debjani Saha wrote:
From looking at the example.dbi it appears that you need to first full out the example.dbi file for your database, and to install the appropriate back end for mysql, so that perl can talk to your mysql database. These are perl packages you need to add to your perl installation. As part of filling out the example.dbi, you also need to decide what will become a record in your greenstone database, and create an sql query that will get your rows out of the database. These rows will then appear as documents in your collection. I have not needed to use DBPlug before, so am not familiar with exactly how it works. The plugin if configured to be included in your greenstone collection appears to read a *.dbi file (created by you and put in your import directory for the collection) and based on that reads your mysql database and imports your database. I am not sure whether it would be easy to preserve the relationships inherant to relational databases in the built greenstone collection importing the data in this way.
-- DL Consulting Greenstone Digital Library and Digitisation Specialists firstname.lastname@example.org www.dlconsulting.com