You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by Pablo Ferrari <pa...@gmail.com> on 2009/09/01 17:48:10 UTC

Adding docs from MySQL and php

Hello all,

I'm new to the list and new to Solr. My name is Pablo, I'm from Spain and
I'm developing a web site using Solr.

I have Solr with the examples working correctly and now I would like to load
the data from a MySQL database using php.
Is the best way to do this to write a php script that get the info from the
MySQL and then generates an XML document to load into Solr? Is there a
maximum size for this XML document? My MySQL database is quite big...

Any help, book or internet tutorial you know will be really appreciated.

Thank you!

Pablo

Re: Adding docs from MySQL and php

Posted by Pablo Ferrari <pa...@gmail.com>.

wow, it looks like DIH already works with relational databases... thanks
again!

2009/9/1 Pablo Ferrari <pa...@gmail.com>

> Thanks Aakash!
>
> I've looked at it and it looks very interesting, the problem is that my
> database is a relational model, therefore I don't have a table with all the
> information, but many tables related to each other by their ids (primary
> keys and foreign keys).
>
> I've been thinking about using DataImportHandler in any of this two ways:
> - Write a script that creates a table with all the information I need for
> searching (it is not very efficient because of duplicate data)
> - Configure DataImportHandler with some JOIN SQL statement
>
> I'll let you know how I did, thanks again!
>
> Pablo
>
> 2009/9/1 Aakash Dharmadhikari <aa...@gmail.com>
>
> hi Pablo,
>>
>>  DataImportHandler might be the best option for you. check this link
>> http://wiki.apache.org/solr/DataImportHandler
>>
>> regards,
>> aakash
>>
>> On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari <pabs.ferrari@gmail.com
>> >wrote:
>>
>> > Hello all,
>> >
>> > I'm new to the list and new to Solr. My name is Pablo, I'm from Spain
>> and
>> > I'm developing a web site using Solr.
>> >
>> > I have Solr with the examples working correctly and now I would like to
>> > load
>> > the data from a MySQL database using php.
>> > Is the best way to do this to write a php script that get the info from
>> the
>> > MySQL and then generates an XML document to load into Solr? Is there a
>> > maximum size for this XML document? My MySQL database is quite big...
>> >
>> > Any help, book or internet tutorial you know will be really appreciated.
>> >
>> > Thank you!
>> >
>> > Pablo
>> >
>>
>
>

Re: Adding docs from MySQL and php

Posted by Pablo Ferrari <pa...@gmail.com>.

Thanks Aakash!

I've looked at it and it looks very interesting, the problem is that my
database is a relational model, therefore I don't have a table with all the
information, but many tables related to each other by their ids (primary
keys and foreign keys).

I've been thinking about using DataImportHandler in any of this two ways:
- Write a script that creates a table with all the information I need for
searching (it is not very efficient because of duplicate data)
- Configure DataImportHandler with some JOIN SQL statement

I'll let you know how I did, thanks again!

Pablo

2009/9/1 Aakash Dharmadhikari <aa...@gmail.com>

> hi Pablo,
>
>  DataImportHandler might be the best option for you. check this link
> http://wiki.apache.org/solr/DataImportHandler
>
> regards,
> aakash
>
> On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari <pabs.ferrari@gmail.com
> >wrote:
>
> > Hello all,
> >
> > I'm new to the list and new to Solr. My name is Pablo, I'm from Spain and
> > I'm developing a web site using Solr.
> >
> > I have Solr with the examples working correctly and now I would like to
> > load
> > the data from a MySQL database using php.
> > Is the best way to do this to write a php script that get the info from
> the
> > MySQL and then generates an XML document to load into Solr? Is there a
> > maximum size for this XML document? My MySQL database is quite big...
> >
> > Any help, book or internet tutorial you know will be really appreciated.
> >
> > Thank you!
> >
> > Pablo
> >
>

Re: Adding docs from MySQL and php

Posted by Aakash Dharmadhikari <aa...@gmail.com>.

hi Pablo,

  DataImportHandler might be the best option for you. check this link
http://wiki.apache.org/solr/DataImportHandler

regards,
aakash

On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari <pa...@gmail.com>wrote:

> Hello all,
>
> I'm new to the list and new to Solr. My name is Pablo, I'm from Spain and
> I'm developing a web site using Solr.
>
> I have Solr with the examples working correctly and now I would like to
> load
> the data from a MySQL database using php.
> Is the best way to do this to write a php script that get the info from the
> MySQL and then generates an XML document to load into Solr? Is there a
> maximum size for this XML document? My MySQL database is quite big...
>
> Any help, book or internet tutorial you know will be really appreciated.
>
> Thank you!
>
> Pablo
>