| | 1 | == Installation Notes . == |
| | 2 | * Got mysqldump from Mark. |
| | 3 | * * * * $ sudo ./mysqlimport5 -u molgenis -p a.sql > database_test |
| | 4 | * (permission denied!) |
| | 5 | * Fixing error in molgenis new distro (hvp_pilot ) missing molgenis jar files. |
| | 6 | * Just noticed that Molgenis has also common_collections jar file . Maybe conflict with peregrine there . |
| | 7 | * Lucene @ mac : |
| | 8 | * Fix classpath at .profile (Users ~ home directory) : |
| | 9 | * * export CLASSPATH=/Users/despoina/Documents/Lucene/lucene-3.0.1/lucene-core-3.0.1.jar:/Users/despoina/Documents/Lucene/lucene-3.0.1/lucene-demos-3.0.1.jar |
| | 10 | * In order to create an index for a directory ".../path/", run : |
| | 11 | * prompt $ java org.apache.lucene.demo.!IndexFiles /...path/ |
| | 12 | * Search the created index by : |
| | 13 | * * prompt: java org.apache.lucene.demo.[wiki:SearchFiles] |
| | 14 | * Locate the database files and create an index on them : |
| | 15 | * Successfully build an index in a.sql dump file of Syndrome book data . Unfortunately when searching a term that exists more that once, only one reference is found ! --> |
| | 16 | * * Enter query: |
| | 17 | * acetylgalactosaminyltransferase |
| | 18 | * Searching for: acetylgalactosaminyltransferase |
| | 19 | * 1 total matching documents |
| | 20 | * 1. /Users/despoina/Documents/SyndromeBookDATA/a.sql |
| | 21 | * So maybe if they are on different tables, or on an xml file ! |
| | 22 | * TODO : will try that on the tables of hvp_pilot : |
| | 23 | * TODO : fill some data |
| | 24 | * TODO increase gene_description size. |
| | 25 | * * changed * <field name="geneDescription" /> TO <field name="geneDescription" type="text" /> |
| | 26 | * TODO : COmmit svn : (problem with javahl --> chflags -R nouchg .) |
| | 27 | * This problem & solution : http://stackoverflow.com/questions/1765232/subclipse-cant-rename-file-os-x |
| | 28 | * Database changed . |
| | 29 | * Text input inserted . |
| | 30 | * Gene description field from table Gene transformed to Text . (in order to increase size). |
| | 31 | * or ....[http://kalanir.blogspot.com/2008/06/indexing-database-using-apache-lucene.html http://kalanir.blogspot.com/2008/06/indexing-database-using-apache-lucene.html] |
| | 32 | * MYSQL on mac : bins @ /opt/local/var/macports/software/mysql5/5.1.45_0/opt/local/bin |
| | 33 | * dbs @ /opt/local/var/db/mysql5 * * |
