== Mysql installation , Lucene links. ==
== MysqlDump & Import commands ==
MysqlImport :

 * How to dump a whole mysql database : (prompt) mysqldump -u username -p database_name > dump.sql
 * How to import a whole database : mysql5 -u username -p database_name < dump.sql
 * Mysqlimport is for importing single tables in the corresponding tables in a mysql DB.

== Lucene index (database) ==
 * http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Search-Engine-versus-DBMS
 * http://www.netomatix.com/products/documentmanagement/lucene4db.aspx (without mysql , is .net & is demo(!))
 * http://kalanir.blogspot.com/2008/06/indexing-database-using-apache-lucene.html (need actual mysql queries , so why to build a index on DB to query myql , and not query mysql direct to the DB?)
 * Convert DB--> xml (d2rq) --> lucene index
   * Install d2rq in mac http://www4.wiwiss.fu-berlin.de/bizer/D2RQ/spec/index.htm:
     * donwload
     * set paths? : add path to d2r in $PATH
     * run  ##$ ./generate-mapping -d com.mysql.jdbc.Driver -u root -p root  ![jdbc:mysql://127.0.0.1/database_test] > database_test.n3     *
   * Something is really wrong with the paths to d2r in macos , In windows it works:
   * 
     * $ ./dump-rdf.bat -u molgenis -p molgenis  -d com.mysql.jdbc.Driver -j jdbc:mysq!l://127.0.0.1/database_test > database_test.rdf
   * So we have Mark's database dump in rdf .!
   * Import the contents of the database_test in the database created for the application hvp_pilot. The scheme is different so individual table should be inserted using mysqlimport. ...HMM mysql is not working here ..
     * * !client-85-075:bin despoina$  mysql5 -u root -p
     * Enter password:
     * ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)
     * So...phpmyadmin: Install php, apache2 from http://2tbsp.com/content/install_apache_2_and_php_5_macports
       * * sudo port install apache...ok !
       * sudo port uninstall apache ..ok
       * sudo port install apache2 ..waiting....ok
       * * port install php5 +apache2 +mysql5 +pear...waiting..
       * ok ..configuring httpd & php ..
         * TODO : fill in /opt/local/etc/php5/php.ini the path to MYSQL sock : mysql.default_socket = /tmp/mysql.sock (Now now there!!)

== Links ==
http://www.khmeritforum.net/redirect.php?tid=1022&goto=lastpost

http://osdir.com/ml/org.w3c.sparql.devel/2008-09/msg00006.html

Also digged up this : (see attachment) : 3.4 page 84