Greenstone Wiki

User Tools

Site Tools

You are here: index » en » user_advanced » greenstone_databases
en:user_advanced:greenstone_databases

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:user_advanced:greenstone_databases [2018/12/07 06:42] – [Using Squirrel SQL Client to load a MySQL DB] anupamaen: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 ====== ====== Information about the databases Greenstone uses ======
  
Line 58: Line 61:
 3. 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.) 3. 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.)
  
-4. Remember to [[http://wiki.greenstone.org/doku.php?id=en:user_advanced:greenstonesqlplugs#getting_and_running_mysql|have the MySQL Server running]] before connecting the Squirrel Client to it. +4. Make sure to [[http://wiki.greenstone.org/doku.php?id=en:user_advanced:greenstonesqlplugs#getting_and_running_mysql|have the MySQL Server running]] 
  
-2. https://www.cdata.com/kb/tech/mysql-jdbc-squirrel-sql.rst+5. Connect the Squirrel Client to it. https://www.cdata.com/kb/tech/mysql-jdbc-squirrel-sql.rst
en/user_advanced/greenstone_databases.1544164931.txt.gz · Last modified: 2018/12/07 06:42 by anupama