Edgewall Software
Home
Trac
Trac Hacks
Genshi
Babel
Bitten
Home
Download
Documentation
Mailing Lists
License
FAQ
Search:
Login
Preferences
Help/Guide
About Trac
Wiki
Timeline
Roadmap
Browse Source
View Tickets
New Ticket
Search
Context Navigation
+0
Start Page
Index
History
Editing MySqlDb
Adjust edit area height:
8
12
16
20
24
28
32
36
40
Edit side-by-side
= MySQL and the MySQLdb Python bindings for MySQL = ''work in progress, only the most critical information is there for now'' Starting with [milestone:0.10] Trac can use MySQL for its DatabaseBackend. Well, sort of. Better is to use [milestone:0.10.3], and only starting with [milestone:0.10.4] will MySQL be fully supported (at least that's the plan). == Requirements == === MySQL === In order to avoid several issues related to the use of unicode characters throughout Trac, we '''''strongly''''' advise MySQL users to only use databases having the ''`utf8`'' character set and the ''`utf8_general_ci`'' collation type. Such databases can be created with the MySQL monitor, like that: {{{ CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; }}} See also #3884. It has also been [comment:ticket:3659:5 recommended] to use InnoDB instead of MyISAM tables, though it's not completely clear at this point if this really helps. [http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html InnoDB] provides referential integrity and transactions, so this should help. === MySQLdb === The recommended version for now is MySQL-python 1.2.1_p2. Other versions (MySQL-python 1.2.0-3.2.2, MySQL-python 1.2.2b2) were reported to have issues (see #3645). On the other hand, MySQL-python-1.2.2b2 was [googlegroups:trac-users:e291b3ecb4a990a1 reported] to solve an `AttributeError: 'array.array' object has no attribute 'startswith'` error seen when viewing a changeset... These problems ought to be fixed in 1.2.2b3; if they are not, or if you have other issues, please file a bug in the [https://sourceforge.net/tracker/?group_id=22307&atid=374932 MySQL-python Bug Tracker]. == Known Issues == === Still Opened === [[TicketQuery(keywords=~mysql&status=!closed&group=milestone)]] === Typical Problems === [[TicketQuery(keywords=~mysql&resolution=worksforme&group=milestone)]] (corresponding [query:keywords=~mysql&status=!closed&group=milestone custom query]) == Conversion == While a more robust method may be created for [milestone:0.10.4] to allow easy conversion from SQLite to MySQL, users have reported success with the [wiki:SqLiteToMySql following method].
Note:
See
WikiFormatting
and
TracWiki
for help on editing wiki content.
Change information
Your email or username:
E-mail address and name can be saved in the
Preferences
Comment about this change (optional):
Note:
See
TracWiki
for help on using the wiki.