Changes between Version 2 and Version 3 of PerlSqliteToMysqlScript


Ignore:
Timestamp:
Mar 28, 2011 8:42:04 PM (3 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