### MySQL to SQLite converter
https://pypi.org/project/mysql-to-sqlite3/
https://github.com/dumblob/mysql2sqlite
https://stackoverflow.com/questions/3890518/convert-mysql-to-sqlite

```
pip install mysql-to-sqlite3
sudo apt install mysql-to-sqlite3
mysql2sqlite --help

https://github.com/techouse/mysql-to-sqlite3

mysqldump --skip-extended-insert --compact aion > aion_mysql.sql
    ./mysql2sqlite aion_mysql.sql | sqlite3 aion.db
```

Converts MySQL dump to SQLite3 compatible dump (including MySQL `KEY xxxxx` statements from the `CREATE` block).

## [](https://github.com/dumblob/mysql2sqlite#usage)Usage
https://github.com/dumblob/mysql2sqlite

[[mysql2sqlite]] file

1. Dump MySQL DB
       
       ```
       mysqldump --skip-extended-insert --compact [options]... DB_name > dump_mysql.sql
       # or
       #mysqldump --no-data -u root -pmyPassword [options]... DB_name > dump_mysql.sql
       ```
       
   2. Convert the dump to SQLite3 DB
       
       ```
       ./mysql2sqlite dump_mysql.sql | sqlite3 mysqlite3.db
       ```

Confirmed working creating a dump from mysql and into sqlite. Yay.

working commands:

sudo mysqldump --skip-extended-insert --compact aion > aion_mysql.sql
./mysql2sqlite aion_mysql.sql | sqlite3 aion.db