Version 3 (modified by anonymous, 7 years ago) (diff)


SQLite to MySQL Script


WARNING: As of Track 0.11.1 (with Bitten) and Python 2.5 this script no longer seems to work.

Script to migrate a SQLite trac database to MySQL

Renewed for mysql from SqliteToPgScript.

Bugs/Feature Requests

Existing bugs and feature requests for SqliteToMySqlScript are here.

If you have any issues, create a new ticket.


Download the zipped source from [download:sqlitetomysqlscript here].


You can check out SqliteToMySqlScript from here using Subversion, or browse the source with Trac.


same as SqliteToPgScript.

usage: sqlite2mysql [options] [site]

sqlite2mysql is used to migrate data from SQLite to MySQL.

  -h, --help            show this help message and exit
  -e <path>, --tracenv=<path>
                        Path to trac environment
  -m <list>, --migrate=<list>
                        Comma separated list of tables to migrate
                        Comma separated list of users to exclude from
                        permission migration
  -w <list>, --wikipages=<list>
                        Comma separated list of wiki page names to ommit from
                        the migration
  -p <uri>, --mysql_uri=<uri>
                        DB URI for MySQL database
  -s <uri>, --sqlite_uri=<uri>
                        DB URI for SQLite database
  --noclean             Do not clear MySQL tables before transfer
 python sqlite2mysql -e /path/to/repos -p 'mysql://user:password@localhost/trac'

Recent Changes

6203 by takayama on 2009-07-15 12:25:37
this is commit test.
3282 by takayama on 2008-02-27 15:50:30

Updated url.

3281 by takayama on 2008-02-27 15:47:59
Added new script sqlite2mysql.


Author: takayama