Skip to main content

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

Project description

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

SQLite3 to MySQL

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

I originally wrote this simple program as a standalone script and published it as a gist as an answer to this Stack Overflow question. Since then quite some people have taken interest in it since it's so simple and effective. Therefore I finally moved my lazy bones and made a GitHub repository :octopus:.

How to run

pip install sqlite3-to-mysql
sqlite3mysql --help

Usage

Usage: sqlite3mysql [OPTIONS]

  Transfer SQLite to MySQL using the provided CLI options.

Options:
  -f, --sqlite-file PATH      SQLite3 database file  [required]
  -t, --sqlite-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.
  -d, --mysql-database TEXT   MySQL database name  [required]
  -u, --mysql-user TEXT       MySQL user  [required]
  -p, --mysql-password TEXT   MySQL password
  -h, --mysql-host TEXT       MySQL host. Defaults to localhost.
  -P, --mysql-port INTEGER    MySQL port. Defaults to 3306.
  --mysql-integer-type TEXT   MySQL default integer field type. Defaults to
                              INT(11).

  --mysql-string-type TEXT    MySQL default string field type. Defaults to
                              VARCHAR(255).

  -T, --use-fulltext          Use FULLTEXT indexes on TEXT columns. Will throw
                              an error if your MySQL version does not support
                              InnoDB FULLTEXT indexes!

  --with-rowid                Transfer rowid columns.
  -c, --chunk INTEGER         Chunk reading/writing SQL records
  -l, --log-file PATH         Log file
  -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.

Source Distribution

sqlite3-to-mysql-1.3.12.tar.gz (27.8 kB view details)

Uploaded Source

Built Distribution

sqlite3_to_mysql-1.3.12-py2.py3-none-any.whl (14.6 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file sqlite3-to-mysql-1.3.12.tar.gz.

File metadata

  • Download URL: sqlite3-to-mysql-1.3.12.tar.gz
  • Upload date:
  • Size: 27.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.6.1 requests/2.25.1 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.54.1 CPython/3.9.0

File hashes

Hashes for sqlite3-to-mysql-1.3.12.tar.gz
Algorithm Hash digest
SHA256 98825acc2294863d10c432fe333748cd3ef476f6de1f40ce9910d587b9d3a1bd
MD5 b659110d84ce92f391e11bf5d3dee1ec
BLAKE2b-256 ea88c6cefba7325365494b637c4ed5b9f90388a9489cc667c5bd5071249c066b

See more details on using hashes here.

File details

Details for the file sqlite3_to_mysql-1.3.12-py2.py3-none-any.whl.

File metadata

  • Download URL: sqlite3_to_mysql-1.3.12-py2.py3-none-any.whl
  • Upload date:
  • Size: 14.6 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.6.1 requests/2.25.1 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.54.1 CPython/3.9.0

File hashes

Hashes for sqlite3_to_mysql-1.3.12-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 8bbcaeb234784dbec10f27d5648b8dd1f9d90fc319c22e82d1eeb1f5147fe324
MD5 139ce431fee1c0e0e5b4e7bdf5710906
BLAKE2b-256 1f2dc8dbe08165e9a42ac5cab4438d92d67e96ac0c81e5d65932573f73bd16dc

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page