mysql to sqlite notes
### 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
- 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