[[PageOutline(2-5,Contents,pullout)]]

= 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.  It's specifically designed for an instance of Trac that has been installed for a while (with lots of extra tables from plugins ) and convert things over.  Using 'dump' doesnt' work in this case because of the mixture of quotes.  It's fairly easy to run and works across multiple machines. 

=== Requirements ===
  - you will need to have installed the DBI, DBD::mysql and DBD::SQLite perl modules
  - you will need to have sqlite3 in your path. 
  - you need to have full permissions on the target database server

== Bugs/Feature Requests == 

Existing bugs and feature requests for PerlSqliteToMysqlScript are 
[report:9?COMPONENT=PerlSqliteToMysqlScript here].

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

== Download ==

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

== Source ==

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

== Example ==
{{{
sandinak@hishost> sqlite2mysql.pl                               
sqlite2mysql.pl {options} [path-to-trac-instance]
        -v              verbose
        -db {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
}}}

== Recent Changes ==

[[ChangeLog(perlsqlitetomysqlscript, 3)]]

== Author/Contributors ==

'''Author:''' [wiki:sandinak] [[BR]]
'''Maintainer:''' [wiki:sandinak] [[BR]]
'''Contributors:'''