wiki:SqliteToMySqlScript

Version 4 (modified by rjollos, 16 months ago) (diff)

Deprecated.

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

Author: takayama
Contributors: