- Different scripts for uploading info. Since it uses Aria Engine, MariaDB must be used (change to MyISAM if using MySQL).
- Modify
config.jsonaccordingly to suit your needs. This example configuration file is used in the different subdirectories.
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"