Greenstone Wiki

User Tools

Site Tools

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

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
en:user_advanced:greenstonesqlplugs [2019/09/05 07:15] – [The short version: Usage instructions] anupamaen:user_advanced:greenstonesqlplugs [2019/09/05 07:16] – [The short version: Usage instructions] anupama
Line 73: Line 73:
      * But **once you log into MySQL client, always first set the connection to use the ''utf8mb4'' character set** before creating or loading databases and tables:\\ <code>mysql> set names utf8mb4;</code>      * But **once you log into MySQL client, always first set the connection to use the ''utf8mb4'' character set** before creating or loading databases and tables:\\ <code>mysql> set names utf8mb4;</code>
      * The GreenstoneSQLPlugs create a **database** called ''<SITENAME>'' for GS3 (which defaults to ''localsite'') and called ''greenstone2'' for GS2.      * The GreenstoneSQLPlugs create a **database** called ''<SITENAME>'' for GS3 (which defaults to ''localsite'') and called ''greenstone2'' for GS2.
-     * Up to 2 **tables** are created for each collection: ''<COLNAME>_metadata'' and ''<COLNAME>_fulltxt'' (note spelling), where hyphens '-' in <COLNAME> are replaced by underscores '_'.+     * Up to 2 **tables** are created for each collection: ''<COLNAME>_metadata'' and ''<COLNAME>_fulltxt'' (note spelling), where COLNAME is the collection name and where hyphens '-' in <COLNAME> are replaced by underscores '_'.
  
 **Notes on GreenstoneSQLPlugin/out configuration options:** **Notes on GreenstoneSQLPlugin/out configuration options:**
en/user_advanced/greenstonesqlplugs.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1