MySQL Data import handler

Hi, I am new to solar and trying for MySQL data import handler. I have 3 tables in mysql. 1) user 2) mast_data 3) child_data The child_data table has foreign key ref of master_data and user. In child_data table, i have the following columns. 1) date 2) fee 3) location 4) type 5) text 6

Re: MySQL Data import handler

On 14 September 2013 18:46, Baskar Sikkayan baskar@gmail.com wrote: Hi, I am new to solar and trying for MySQL data import handler. I have 3 tables in mysql. [...] Your question is unclear, and you would probably benefit by doing some basic homework on Solr and importing data

Re: MySQL Data import handler

2013 18:46, Baskar Sikkayan baskar@gmail.com wrote: Hi, I am new to solar and trying for MySQL data import handler. I have 3 tables in mysql. [...] Your question is unclear, and you would probably benefit by doing some basic homework on Solr and importing data into it. Please start

Re: MySQL Data import handler

On 14 September 2013 20:07, Baskar Sikkayan baskar@gmail.com wrote: Hi Gora, Thanks a lot for your reply. My requirement is to combine 3 tables in mysql for search operation and planning to sync these 3 tables( not all the columns ) in Apache Solr. Whenever there is any change( adding

Re: MySQL Data import handler

Hi, If i am supposed to go with Java client, should i still do any configurations in solrconfig.xml or schema.xml. Thanks, Baskar.S On Sat, Sep 14, 2013 at 8:46 PM, Gora Mohanty g...@mimirtech.com wrote: On 14 September 2013 20:07, Baskar Sikkayan baskar@gmail.com wrote: Hi Gora,

Re: MySQL Data import handler

Hi Baskar, Just create a single schema.xml which should contains required fields from 3 tables. Add a status column to child table.i.e 1 = add 2 = update 3 = delete 4 = indexed Etc Write a program using solrj which will read the status and do thing accordingly. Rgds AJ On 15-Sep-2013,