Differences

This shows you the differences between two versions of the page.

--- en:user_advanced:greenstone_databases [2017/09/08 08:39] – [Using Squirrel SQL Client to manage Relational Databases] anupama
+++ en:user_advanced:greenstone_databases [2023/03/13 01:46] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Information about the databases Greenstone uses ======
 Greenstone comes with several database systems included: [[http://wiki.greenstone.org/doku.php?id=en:user_advanced:collection_database|gdbm, jdbm, SQLite]]. When building a collection, you can control which of these is used. In GS3, the default is jdbm.
@@ Line 7: / Line 12: @@
 Note that Greenstone databases with gdb and jdb extensions are flat databases, not relational DBs. So that's Greenstone's collection level databases and GS2's user and history databases.
-=== Using Squirrel SQL Client to manage Relational Databases ===
+===== Using Squirrel SQL Client to manage Relational Databases =====
 If you wanted an application with a friendly interface to manage any relational databases that Greenstone creates, then try Squirrel SQL Client, which is for relational databases.
@@ Line 43: / Line 48: @@
 For further information on using Squirrel SQL, consult its documentation, which can be found off http://squirrel-sql.sourceforge.net/.
+==== Using Squirrel SQL Client to load a MySQL DB ====
+On Windows:
+. Download JDBC driver for MySQL from https://dev.mysql.com/downloads/connector/j/
+  * Under //Select Operating System//, choose //Platform Independent//.
+See https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-installing.html for installation information
+. Unzip and copy the top level jar file, ''mysql-connector-java-8.0.13.jar'' and the ''lib'' folder into the Squirrel SQL Client installation folder's ''lib'' subfolder.
+. Follow the instructions at https://www.cdata.com/kb/tech/mysql-jdbc-squirrel-sql.rst \\ but when they say configure the "server" for connection properties, configure the "host" instead and set this to 127.0.0.1 instead of the default of localhost. Also set the username (root by default) and pwd connection properties. (Perhaps set the name property of the database too, although this shouldn't be necessary? If testing GreenstoneSQLPlugs, the database name is ''localsite'' for GS3 and ''greenstone2'' for GS2.)
+. Make sure to [[http://wiki.greenstone.org/doku.php?id=en:user_advanced:greenstonesqlplugs#getting_and_running_mysql|have the MySQL Server running]]
+. Connect the Squirrel Client to it. https://www.cdata.com/kb/tech/mysql-jdbc-squirrel-sql.rst