| | 1 | == Mysql installation , Lucene links. == |
| | 2 | == MysqlDump & Import commands == |
| | 3 | MysqlImport : |
| | 4 | |
| | 5 | * How to dump a whole mysql database : (prompt) mysqldump -u username -p database_name > dump.sql |
| | 6 | * How to import a whole database : mysql5 -u username -p database_name < dump.sql |
| | 7 | * Mysqlimport is for importing single tables in the corresponding tables in a mysql DB. |
| | 8 | |
| | 9 | == Lucene index (database) == |
| | 10 | * http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Search-Engine-versus-DBMS |
| | 11 | * http://www.netomatix.com/products/documentmanagement/lucene4db.aspx (without mysql , is .net & is demo(!)) |
| | 12 | * 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?) |
| | 13 | * Convert DB--> xml (d2rq) --> lucene index |
| | 14 | * Install d2rq in mac http://www4.wiwiss.fu-berlin.de/bizer/D2RQ/spec/index.htm: |
| | 15 | * donwload |
| | 16 | * set paths? : add path to d2r in $PATH |
| | 17 | * run ##$ ./generate-mapping -d com.mysql.jdbc.Driver -u root -p root ![jdbc:mysql://127.0.0.1/database_test] > database_test.n3 * |
| | 18 | * Something is really wrong with the paths to d2r in macos , In windows it works: |
| | 19 | * |
| | 20 | * $ ./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 |
| | 21 | * So we have Mark's database dump in rdf .! |
| | 22 | * 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 .. |
| | 23 | * * !client-85-075:bin despoina$ mysql5 -u root -p |
| | 24 | * Enter password: |
| | 25 | * ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2) |
| | 26 | * So...phpmyadmin: Install php, apache2 from http://2tbsp.com/content/install_apache_2_and_php_5_macports |
| | 27 | * * sudo port install apache...ok ! |
| | 28 | * sudo port uninstall apache ..ok |
| | 29 | * sudo port install apache2 ..waiting....ok |
| | 30 | * * port install php5 +apache2 +mysql5 +pear...waiting.. |
| | 31 | * ok ..configuring httpd & php .. |
| | 32 | * TODO : fill in /opt/local/etc/php5/php.ini the path to MYSQL sock : mysql.default_socket = /tmp/mysql.sock (Now now there!!) |
| | 33 | |
| | 34 | == Links == |
| | 35 | http://www.khmeritforum.net/redirect.php?tid=1022&goto=lastpost |
| | 36 | |
| | 37 | http://osdir.com/ml/org.w3c.sparql.devel/2008-09/msg00006.html |
| | 38 | |
| | 39 | Also digged up this : (see attachment) : 3.4 page 84 |
