copy_db.pl - Migrate data between translation databases
copy_db.pl copies all the data in known tables ('files', 'strings', 'items', 'translations' and 'fingerprints') from source to target translation database. This is useful when migrating to a new database type (e.g. from SQLite to MySQL). The target database must exist, but may be empty (in this case the script will populate its structure). If the target database exists with all the tables needed, the schema of the copied tables must be the same.
copy_db.pl --source=DBI:SQLite:dbname=/path/to/translate.db3 --target=DBI:mysql:database=translate --target-user=root --target-password
Use --help option for more information.
--help
Use --man for the full documentation.
--man
Show help on program usage and options. For a more verbose output, use --man
Show all available documentation on this program.
Source database to copy from, as a DBI-compatible connection string. This parameter is required.
Source database username (optional; not needed for SQLite databases).
Source database password (optional; not needed for SQLite databases). If password is ommitted, you will be prompted to enter it securely (with no echo).
Target database to copy into, as a DBI-compatible connection string. This parameter is required.
Target database username (optional; not needed for SQLite databases).
Target database password (optional; not needed for SQLite databases). If password is ommitted, you will be prompted to enter it securely (with no echo).
To install Serge, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Serge
CPAN shell
perl -MCPAN -e shell install Serge
For more information on module installation, please visit the detailed CPAN module installation guide.