| 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 | |