Re: Adding docs from MySQL and php
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.ferr...@gmail.comwrote: 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
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 aaka...@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.ferr...@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
wow, it looks like DIH already works with relational databases... thanks again! 2009/9/1 Pablo Ferrari pabs.ferr...@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 aaka...@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.ferr...@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