| | 60 | == Opal Post Installation |
| | 61 | |
| | 62 | See: |
| | 63 | - [[http://wiki.obiba.org/display/OPALDOC/Post+Installation+Set-up]] |
| | 64 | |
| | 65 | == Opal Database Setup |
| | 66 | |
| | 67 | See: |
| | 68 | - [[http://wiki.obiba.org/display/OPALDOC/Databases+Administration]] |
| | 69 | |
| | 70 | === 1. Update MySql Config |
| | 71 | |
| | 72 | 1. The config file for MySQL files on a LAMP server is stored at `/db/mysql/etc/my.cnf` |
| | 73 | 2. Change the default character set in the `[mysqld]` section: |
| | 74 | |
| | 75 | {{{ |
| | 76 | default-character-set=utf8 |
| | 77 | default-collation=utf8_bin |
| | 78 | }}} |
| | 79 | |
| | 80 | 3. Change the storage engine in the `[mysqld]` section: |
| | 81 | |
| | 82 | {{{ |
| | 83 | default-storage-engine=INNODB |
| | 84 | }}} |
| | 85 | |