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