tod/mysql-to-sqlite

Laravel mysql-to-sqlite

This is a Laravel wrapper for esperlu's mysql2sqlite.sh which converts a mysqldump to an Sqlite 3 compatible file., _(*1)

• Usage
• Configuration
• Installation

, _(*2)

Usage

You can run the default configuration, _(*3)

php artisan db:mysql-to-sqlite

Running a single, default conversion configuration:, _(*4)

php artisan db:mysql-to-sqlite customerServiceDBForCI

Configuration

• Publish the config...

For Laravel, _(*5)

Publish the config..., _(*6)

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

Add the following to app/Providers/AppServiceProvider.php, _(*7)

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, _(*8)

Publish the config..., _(*9)

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

Add the following to app/bootstrap/app.php, _(*10)

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

Installation

You're probably only using this for development, so we'll use require-dev:, _(*12)

composer require --dev realpagelouisville/mysql-to-sqlite:~1.*