[[PageOutline(2-5,Contents,pullout)]]
= SQLite to MySQL Script =

{{{
#!html
<div class="system-message" float="left" overflow="auto">
<b>Notice:</b> This plugin is deprecated. See the <a href=http://trac-hacks.org/wiki/TracMigratePlugin>TracMigratePlugin</a>.
</div>
}}}

== 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 
[report:9?COMPONENT=SqliteToMySqlScript here].

If you have any issues, create a 
[http://trac-hacks.org/newticket?component=SqliteToMySqlScript&owner=takayama new ticket].

== Download ==

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

== Source ==

You can check out SqliteToMySqlScript from [http://trac-hacks.org/svn/sqlitetomysqlscript here] using Subversion, or [source:sqlitetomysqlscript browse the source] with Trac.

== Example ==

same as SqliteToPgScript.

{{{
#!sh
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 ==

[[ChangeLog(sqlitetomysqlscript, 3)]]

== Author/Contributors ==

'''Author:''' [wiki:takayama] [[BR]]
'''Maintainer:''' ''none (deprecated)'' [[BR]]
'''Contributors:'''