NAME
copy_db.pl - Migrate data between translation databases
DESCRIPTION
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.
SYNOPSIS
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.
Use --man for the full documentation.
OPTIONS
- -?, --help
-
Show help on program usage and options. For a more verbose output, use
--man - --man
-
Show all available documentation on this program.
- -s DSN, --source=DSN
-
Source database to copy from, as a DBI-compatible connection string. This parameter is required.
- -su user, --source-user=user
-
Source database username (optional; not needed for SQLite databases).
- -sp [password], --source-password[=password]
-
Source database password (optional; not needed for SQLite databases). If password is ommitted, you will be prompted to enter it securely (with no echo).
- -t DSN, --target=DSN
-
Target database to copy into, as a DBI-compatible connection string. This parameter is required.
- -tu user, --target-user=user
-
Target database username (optional; not needed for SQLite databases).
- -tp [password], --target-password[=password]
-
Target database password (optional; not needed for SQLite databases). If password is ommitted, you will be prompted to enter it securely (with no echo).