Skip to content

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

MySQL scripts

  • Different scripts for uploading info. Since it uses Aria Engine, MariaDB must be used (change to MyISAM if using MySQL).
  • Modify config.json accordingly to suit your needs. This example configuration file is used in the different subdirectories.

Notes

Some problems that can be found:

  • Fixing table encodings

      SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME," 
      CONVERT TO CHARACTER SET latin1 COLLATE 'latin1_swedish_ci'") AS ExecuteTheString
      FROM INFORMATION_SCHEMA.TABLES
      WHERE TABLE_SCHEMA="biosql"