• Stars
    star
    209
  • Rank 188,325 (Top 4 %)
  • Language
    Python
  • License
    MIT License
  • Created over 5 years ago
  • Updated 3 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Transfer data from MySQL to SQLite

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.

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. Can not be used together with
                                  --exclude-mysql-tables.

  -e, --exclude-mysql-tables TUPLE
                                  Transfer all tables except these specific
                                  tables (space separated table names).
                                  Implies --without-foreign-keys which
                                  inhibits the transfer of foreign keys. Can
                                  not be used together with --mysql-tables.

  -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.
  --debug                         Debug mode. Will throw exceptions.
  --version                       Show the version and exit.
  --help                          Show this message and exit.

More Repositories

1

sqlite3-to-mysql

Transfer data from SQLite to MySQL
Python
360
star
2

intl-date-time

International DateTime for Laravel Nova
Vue
57
star
3

alfred-tailwindcss-docs

Search the Tailwind CSS documentation using Alfred
Dart
54
star
4

select-auto-complete

An auto-completing Laravel Nova search field
Vue
31
star
5

alfred-gitmoji

Search for Gitmojis using Alfred
Dart
25
star
6

alfred-convert

Convert between different units with Alfred
Dart
21
star
7

alfred-stackoverflow

Search for answers on StackOverflow from Alfred
Dart
13
star
8

alfred_workflow

A helper library in Dart for authors of workflows for Alfred
Dart
12
star
9

alfred-react-docs

Search the React documentation using Alfred
Dart
8
star
10

total-records

A Laravel Nova card that displays the total number of records of a specific model
PHP
8
star
11

alfred-flutter-docs

Search the Flutter documentation using Alfred
Dart
7
star
12

alfred-vue-docs

Search the Vue.js v3 and v2 documentation using Alfred.
Dart
7
star
13

wizard

Basic single page application CMS built with Laravel, Vue.js, Element UI and Tailwind CSS
PHP
6
star
14

alfred-django-docs

Search the Django documentation using Alfred and Algolia
Dart
6
star
15

alfred-emoji

This workflow allows you to quickly search for and copy emojis to your clipboard.
Dart
5
star
16

alfred-nova-docs

Search the Laravel Nova documentation using Alfred and Algolia
Dart
5
star
17

php-date-interval-timezone-bug

A demonstration of a nasty PHP DateInterval bug related to timezones and DST
PHP
3
star
18

qs

A query string encoding and decoding library for Dart. Ported from qs for JavaScript.
Dart
3
star
19

slovenian-date-time

Slovenian datepicker for Laravel Nova
Vue
2
star
20

alfred-laravel-docs

Search the Laravel documentation using Alfred
Dart
2
star
21

alfred-flask-docs

Search the Flask documentation using Alfred and Algolia
Dart
2
star
22

alfred-dart-docs

Search the Dart documentation using Alfred
Dart
2
star
23

es6-boilerplate

A basic JavaScript ES6 boilerplate setup using Webpack, Babel and Lite-Server
JavaScript
1
star
24

alfred-cakephp-docs

Search the CakePHP documentation using Alfred and Algolia
Dart
1
star