Skip to main content
Python Software Foundation 20th Year Anniversary Fundraiser  Donate today!

A simple Python tool to transfer data from MySQL to SQLite 3

Project description

PyPI Downloads PyPI - Python Version MySQL Support MariaDB Support GitHub license Contributor Covenant Code style: black Codacy Badge Build Status codecov GitHub stars

MySQL to SQLite3

A simple Python tool to transfer data from MySQL to SQLite 3.

This is the long overdue complimentary tool to my SQLite3 to MySQL. It transfers all data from a MySQL database to a SQLite3 database.

How to run

pip install mysql-to-sqlite3
mysql2sqlite --help


Usage: mysql2sqlite [OPTIONS]

  Transfer MySQL to SQLite using the provided CLI options.

  -f, --sqlite-file PATH       SQLite3 database file  [required]
  -d, --mysql-database TEXT    MySQL database name  [required]
  -u, --mysql-user TEXT        MySQL user  [required]
  -p, --prompt-mysql-password  Prompt for MySQL password
  --mysql-password TEXT        MySQL password
  -t, --mysql-tables TEXT      Transfer only these specific tables (space
                               separated table names). Implies --without-
                               foreign-keys which inhibits the transfer of
                               foreign keys.

  -X, --without-foreign-keys   Do not transfer foreign keys.
  -h, --mysql-host TEXT        MySQL host. Defaults to localhost.
  -P, --mysql-port INTEGER     MySQL port. Defaults to 3306.
  -S, --skip-ssl               Disable MySQL connection encryption.
  -c, --chunk INTEGER          Chunk reading/writing SQL records
  -l, --log-file PATH          Log file
  -V, --vacuum                 Use the VACUUM command to rebuild the SQLite
                               database file, repacking it into a minimal
                               amount of disk space

  --use-buffered-cursors       Use MySQLCursorBuffered for reading the MySQL
                               database. This can be useful in situations
                               where multiple queries, with small result sets,
                               need to be combined or computed with each

  -q, --quiet                  Quiet. Display only errors.
  --version                    Show the version and exit.
  --help                       Show this message and exit.

GUI wrapper

Aref Alikhani has developed a GUI wrapper called Berudele for this tool in case you're not comfortable with the CLI interface.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for mysql-to-sqlite3, version 1.4.0
Filename, size File type Python version Upload date Hashes
Filename, size mysql_to_sqlite3-1.4.0-py2.py3-none-any.whl (13.9 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size mysql-to-sqlite3-1.4.0.tar.gz (28.1 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page