77 | | documented in more details in the MySqlDb page. Use this only if you don't have other choice, and be warned that there can be many issues, in particular related to the unicode support and the repository cache support. Some users are nevertheless using MySQL successfully, so it ''might'' work for you. The primary supported backends though are PostgreSQL and SQLite. |
78 | | |
79 | | |
80 | | * Have a working copy of MySQL version 4.1.12 or greater. |
81 | | * [http://sourceforge.net/projects/mysql-python MySQLdb] - Python database driver for MySQL |
82 | | * Create a database and user for your Trac environment |
83 | | {{{ |
84 | | % mysqladmin create dbname |
85 | | % mysql |
86 | | > grant all privileges on dbname.* to dbuser@dbhost identified by 'dbpass'; |
87 | | > use dbname; |
88 | | > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
89 | | > quit |
90 | | |
91 | | NB - it may be necessary to use a different collation. In some cases, where there is a |
92 | | case-sensitive collision between 2 files in svn (/myrepos/path/my.txt and /myrepos/path/MY.txt) |
93 | | utf8_general_ci is case-*in*sensitive, so utf8_bin will allow case-sensitive keys. For example |
94 | | > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; |
95 | | If during index of respository you get 1062 - Duplicate Entry this may be a cause |
96 | | see ticket 3676 |
97 | | |
98 | | }}} |
99 | | |
100 | | |
| 77 | documented in more details in the MySqlDb page. Use this only if you don't have other choice, and be warned that there can be many issues, in particular related to the unicode support and the repository cache support. Some users are nevertheless using MySQL successfully, so it ''can'' work for you, provided you carefully read and follow the instructions given in the MySqlDb page. |