pshentsoff/mysql-to-sqlite

Create & convert MySQL dump to SQLite DB file

v1.2.1 2017-04-12 05:20 UTC

Requires

• php: >=5.6.0
• illuminate/console: >=5.0
• illuminate/contracts: >=5.0
• illuminate/support: >=5.0
• symfony/process: >=2.7

Requires (Dev)

• phpspec/phpspec: ~2.3
• squizlabs/php_codesniffer: ~2.5
• symfony/var-dumper: dev-master

MIT

• Ben Kuhl
• Denis Riabiy

README

This is a Laravel wrapper for esperlu's mysql2sqlite.sh which converts a mysqldump to an Sqlite 3 compatible file.

• Installation
• Usage
• Configuration

Installation

You're probably only using this for development, so we'll use require-dev:

composer require --dev pshentsoff/mysql-to-sqlite

Usage

You can run the default configuration

php artisan db:mysql-to-sqlite

Running a single, default conversion configuration:

php artisan db:mysql-to-sqlite customerServiceDBForCI

Configuration

• Publish the config...

For Laravel

Publish the config...

php artisan vendor:publish --provider="MysqlToSqlite\ServiceProvider"

Add the following to app/Providers/AppServiceProvider.php

public function register()
{
    // Class may not be there if it was loaded as a dev dependency
    if (class_exists('MysqlToSqlite\ServiceProvider')) {
        $this->app->register(\MysqlToSqlite\ServiceProvider::class);
    }
}

For Lumen

Publish the config...

cp vendor/realpagelouisville/mysql-to-sqlite/config/mysql-to-sqlite.php config/mysql-to-sqlite.php

Add the following to app/bootstrap/app.php

// Class may not be there if it was loaded as a dev dependency
if(class_exists('MysqlToSqlite\ServiceProvider')) {
    $app->register(MysqlToSqlite\ServiceProvider::class);
}