|Version 4 (modified by rjollos, 16 months 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.
If you have any issues, create a new ticket.
Download the zipped source from here.
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'