gituser/production/: mysql-to-sqlite3-1.4.10 metadata and description

Homepage Simple index

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

author Klemen Tusar
author_email techouse@gmail.com
classifiers
  • Development Status :: 5 - Production/Stable
  • Environment :: Console
  • Intended Audience :: End Users/Desktop
  • Intended Audience :: Developers
  • Intended Audience :: System Administrators
  • License :: OSI Approved :: MIT License
  • Operating System :: OS Independent
  • Programming Language :: Python
  • Programming Language :: Python :: 2
  • Programming Language :: Python :: 2.7
  • Programming Language :: Python :: 3
  • Programming Language :: Python :: 3.5
  • Programming Language :: Python :: 3.6
  • Programming Language :: Python :: 3.7
  • Programming Language :: Python :: 3.8
  • Programming Language :: Python :: 3.9
  • Programming Language :: Python :: 3.10
  • Programming Language :: Python :: Implementation :: CPython
  • Topic :: Database
description_content_type text/markdown
license MIT
project_urls
  • Source, https://github.com/techouse/mysql-to-sqlite3
requires_dist
  • pytimeparse (>=1.1.8)
  • simplejson (>=3.16.0)
  • six (>=1.12.0)
  • tqdm (>=4.35.0)
  • tabulate (<0.8.6) ; python_version < "3.5"
  • Click (<8.0.0,>=7.0) ; python_version < "3.6"
  • mysql-connector-python (<8.0.24,>=8.0.18) ; python_version < "3.6"
  • python-slugify (<5.0.0,>=3.0.3) ; python_version < "3.6"
  • tabulate ; python_version >= "3.5"
  • Click (>=7.0) ; python_version >= "3.6"
  • mysql-connector-python (>=8.0.18) ; python_version >= "3.6"
  • python-slugify (>=3.0.3) ; python_version >= "3.6"
requires_python >=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*
File Tox results History
mysql_to_sqlite3-1.4.10-py2.py3-none-any.whl
Size
15 KB
Type
Python Wheel
Python
2.7

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

Usage: mysql2sqlite [OPTIONS]

  Transfer MySQL to SQLite using the provided CLI options.

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 TUPLE        Transfer only these specific tables (space
                                  separated table names). Implies --without-
                                  foreign-keys which inhibits the transfer of
                                  foreign keys.

  -L, --limit-rows INTEGER        Transfer only a limited number of rows from
                                  each table.

  -C, --collation [BINARY|NOCASE|RTRIM]
                                  Create datatypes of TEXT affinity using a
                                  specified collation sequence.  [default:
                                  BINARY]

  -K, --prefix-indices            Prefix indices with their corresponding
                                  tables. This ensures that their names remain
                                  unique across the SQLite database.

  -X, --without-foreign-keys      Do not transfer foreign keys.
  -W, --without-data              Do not transfer table data, DDL only.
  -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
  --json-as-text                  Transfer JSON columns as TEXT.
  -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 other.

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