SQLite to MySQL Script

Notice: This plugin is deprecated. See the TracMigratePlugin.

Description

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

Download the zipped source from here.

Source

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

Example

same as SqliteToPgScript.

usage: sqlite2mysql [options] [site]

sqlite2mysql is used to migrate data from SQLite to MySQL.

options:
  -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
  --exclude_perms=<list>
                        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 07/15/09 12:25:37

this is commit test.

[3282] by takayama on 02/27/08 15:50:30

Updated url.

- SqliteToMySqlScript -

[3281] by takayama on 02/27/08 15:47:59

Added new script sqlite2mysql.

[3280] by takayama on 02/27/08 15:44:49

New hack SqliteToMySqlScript, created by takayama

Author/Contributors

Author: takayama
Maintainer: none (deprecated)
Contributors: