Utilities and helpful scripts

Creating SQLite database

To create SQLite database from MySql there is a script:

$CCDB_HOME/ scripts/mysql2sqlite/mysql2sqlite.sh

It accepts the same arguments as mysqldump as connection parameters. To use it:

./mysql2sqlite.sh -u <user> -h <host> <dbname>| sqlite3 database.sqlite

So if one has CCDB connection string:

mysql://ccdb_user@mysqlhost/ccdb

One runs the script as:

./mysql2sqlite.sh -u ccdb_user -h mysqlhost ccdb| sqlite3 database.sqlite