Skip to main content

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

Project description

PyPI PyPI - Downloads PyPI - Python Version MySQL Support MariaDB Support GitHub license Contributor Covenant PyPI - Format Code style: black Codacy Badge Test Status CodeQL Status Publish PyPI Package Status Publish Docker Image codecov GitHub Sponsors GitHub stars

SQLite3 to MySQL

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

How to run

pip install sqlite3-to-mysql
sqlite3mysql --help

Usage

Usage: sqlite3mysql [OPTIONS]

Options:
  -f, --sqlite-file PATH          SQLite3 database file  [required]
  -t, --sqlite-tables TUPLE       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.
  -W, --ignore-duplicate-keys     Ignore duplicate keys. The default behavior
                                  is to create new ones with a numerical
                                  suffix, e.g. 'exising_key' ->
                                  'existing_key_1'
  -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
  -h, --mysql-host TEXT           MySQL host. Defaults to localhost.
  -P, --mysql-port INTEGER        MySQL port. Defaults to 3306.
  -k, --mysql-socket PATH         Path to MySQL unix socket file.
  -S, --skip-ssl                  Disable MySQL connection encryption.
  -i, --mysql-insert-method [DEFAULT|IGNORE|UPDATE]
                                  MySQL insert method. DEFAULT will throw
                                  errors when encountering duplicate records;
                                  UPDATE will update existing rows; IGNORE
                                  will ignore insert errors. Defaults to
                                  IGNORE.
  -E, --mysql-truncate-tables     Truncates existing tables before inserting
                                  data.
  --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).
  --mysql-text-type [LONGTEXT|MEDIUMTEXT|TEXT|TINYTEXT]
                                  MySQL default text field type. Defaults to
                                  TEXT.
  --mysql-charset TEXT            MySQL database and table character set
                                  [default: utf8mb4]
  --mysql-collation TEXT          MySQL database and table collation
  -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
  -K, --mysql-skip-create-tables  Skip creating tables in MySQL.
  -J, --mysql-skip-transfer-data  Skip transferring data to MySQL.
  -l, --log-file PATH             Log file
  -q, --quiet                     Quiet. Display only errors.
  --debug                         Debug mode. Will throw exceptions.
  --version                       Show the version and exit.
  --help                          Show this message and exit.

Docker

If you don't want to install the tool on your system, you can use the Docker image instead.

docker run -it \
    --workdir $(pwd) \
    --volume $(pwd):$(pwd) \
    --rm ghcr.io/techouse/sqlite3-to-mysql:latest \
    --sqlite-file baz.db \
    --mysql-user foo \
    --mysql-password bar \
    --mysql-database baz \
    --mysql-host host.docker.internal

This will mount your host current working directory (pwd) inside the Docker container as the current working directory. Any files Docker would write to the current working directory are written to the host directory where you did docker run. Note that you have to also use a special hostname host.docker.internal to access your host machine from inside the Docker container.

Homebrew

If you're on macOS, you can install the tool using Homebrew.

brew tap techouse/sqlite3-to-mysql
brew install sqlite3-to-mysql
sqlite3mysql --help

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-2.4.1.tar.gz (43.5 kB view details)

Uploaded Source

Built Distribution

sqlite3_to_mysql-2.4.1-py3-none-any.whl (20.5 kB view details)

Uploaded Python 3

File details

Details for the file sqlite3_to_mysql-2.4.1.tar.gz.

File metadata

  • Download URL: sqlite3_to_mysql-2.4.1.tar.gz
  • Upload date:
  • Size: 43.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for sqlite3_to_mysql-2.4.1.tar.gz
Algorithm Hash digest
SHA256 c09b7b25ea61602f74bd24243a85258306d9ec69c56440b427f27803c9d0a51e
MD5 6f61e78c157cf982099e09cdcd0da288
BLAKE2b-256 d1b54dc438168103b3af1afb8a9c5902c2c7ff034a95264c2a2ea2f31230bbf9

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite3_to_mysql-2.4.1.tar.gz:

Publisher: publish.yml on techouse/sqlite3-to-mysql

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlite3_to_mysql-2.4.1-py3-none-any.whl.

File metadata

File hashes

Hashes for sqlite3_to_mysql-2.4.1-py3-none-any.whl
Algorithm Hash digest
SHA256 78c8b1f007969dbcc99c2c3e5e2e905bb5bbb53f9779a0493dbd419086ed4d4e
MD5 35c2b7d5728495be2953f6e344a27aed
BLAKE2b-256 5855a89fb86875e98ec6122dae97beb34078321a4637eda14f1cb230ce57d228

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite3_to_mysql-2.4.1-py3-none-any.whl:

Publisher: publish.yml on techouse/sqlite3-to-mysql

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

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