Changes between Version 2 and Version 3 of PerlSqliteToMysqlScript


Ignore:
Timestamp:
Mar 28, 2011, 8:42:04 PM (4 years ago)
Author:
sandinak
Comment:

updating with cleaned up help

Legend:

Unmodified
Added
Removed
Modified
  • PerlSqliteToMysqlScript

    v2 v3  
    55== Description ==
    66
    7 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 fairly easy to run and works across multiple machines.
     7This script was written in self defense as the conversion process is particularly painful. 
     8
     9The 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.
     10
     11=== Requirements ===
     12  - you will need to have installed the DBI, DBD::mysql and DBD::SQLite perl modules
     13  - you will need to have sqlite3 in your path.
     14  - you need to have full permissions on the target database server
    815
    916== Bugs/Feature Requests ==
     
    2532== Example ==
    2633{{{
    27  > sqlite2mysql.pl                               
    28 sqlite2mysql.pl {options}
     34sandinak@hishost> sqlite2mysql.pl                               
     35sqlite2mysql.pl {options} [path-to-trac-instance]
    2936        -v              verbose
    30         -dn {name}      name of the MySQL database
     37        -db {name}      name of the MySQL database
    3138        -dh {hostname}  hostname of the database server
    3239        -du {user}      username for this database
    3340        -dp {pass}      password for this database
    34         -tp {path}      full path to the trac instance
    3541}}}
    3642