en:user_advanced:greenstone_databases
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
en:user_advanced:greenstone_databases [2017/09/08 08:39] – [Using Squirrel SQL Client to manage Relational Databases] anupama | en:user_advanced:greenstone_databases [2018/12/07 06:35] – [Using Squirrel SQL Client to load a MySQL DB] anupama | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Information about the databases Greenstone uses ====== | ||
+ | |||
Greenstone comes with several database systems included: [[http:// | Greenstone comes with several database systems included: [[http:// | ||
Line 7: | Line 9: | ||
Note that Greenstone databases with gdb and jdb extensions are flat databases, not relational DBs. So that's Greenstone' | Note that Greenstone databases with gdb and jdb extensions are flat databases, not relational DBs. So that's Greenstone' | ||
- | === 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. | 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 45: | ||
For further information on using Squirrel SQL, consult its documentation, | For further information on using Squirrel SQL, consult its documentation, | ||
+ | |||
+ | |||
+ | ==== Using Squirrel SQL Client to load a MySQL DB ==== | ||
+ | On Windows: | ||
+ | |||
+ | 1. Download JDBC driver for MySQL from https:// | ||
+ | * Under //Select Operating System//, choose //Platform Independent// | ||
+ | See https:// | ||
+ | |||
+ | 2. Unzip and copy the top level jar file, '' | ||
+ | |||
+ | 3. Follow the instructions at https:// | ||
+ | |||
+ | 4. Remember to [[http:// | ||
+ | |||
+ | |||
+ | 2. https:// |
en/user_advanced/greenstone_databases.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1