?????? (Shalini) wrote:> Hello All,
> i m new to xapian .I want to ask that i have database in
> mysql.I want to search in it .Is there any provision with the help of which
> we can do searching over MySQL database or else we can shift the
> database of
> MySQL into Xapian databasa.
> Shalini
See the "dbi2omega" perl script in the omega application, which will
dump a mysql table to a format suitable for indexing with Xapian (using
the scriptindex tool, also in the omega application). You may need to
modify this script a little if you have a more complex database than
that (or possibly create a database view containing the data you want to
index).
If you need closer integration, you might want to set up triggers to
cause immediate updates - this is perfectly feasible, but there's
nothing already written in the Xapian distribution to do this sort of thing.
--
Richard