Utilities and helpful scripts

Creating SQLite database

there is a script to create SQLite database from MySql:

$CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh

It accepts the same arguments as mysqldump. The common use of it (in terms of CCDB):

./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

Don't forget -p flag if password is used for CCDB MySQL db.