wiki:PerlSqliteToMysqlScript

Version 1 (modified by sandinak, 3 years ago) (diff)

New hack PerlSqliteToMysqlScript, created by sandinak

Perl Script for converting from SQLite to MySQL

Description

This script was written in self defense as the conversion process is particularly painful. The script will fix schema, and indexes to work correctly.

Bugs/Feature Requests

Existing bugs and feature requests for PerlSqliteToMysqlScript are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

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

Example

> sqlite2mysql.pl

sqlite2mysql.pl {options}

-v verbose -dn {name} name of the MySQL database -dh {hostname} hostname of the database server -du {user} username for this database -dp {pass} password for this database -tp {path} full path to the trac instance

Recent Changes

[9994] by sandinak on 2011-03-28 22:15:30
Fixed non-localhost based updates.
[9993] by sandinak on 2011-03-28 20:46:54
fixing STDERR redirect problem
[9992] by sandinak on 2011-03-28 20:30:49
initial checkin

Author/Contributors

Author: sandinak
Maintainer: sandinak
Contributors: