• Stars
    star
    360
  • Rank 118,230 (Top 3 %)
  • Language
    Python
  • License
    MIT License
  • Created over 6 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 SQLite to MySQL

PyPI Downloads PyPI - Python Version MySQL Support MariaDB Support GitHub license Contributor Covenant 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.

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 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.
  -S, --skip-ssl                  Disable MySQL connection encryption.
  -i, --mysql-insert-method [UPDATE|IGNORE|DEFAULT]
                                  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 [MEDIUMTEXT|TEXT|TINYTEXT|LONGTEXT]
                                  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
  -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.

More Repositories

1

mysql-to-sqlite3

Transfer data from MySQL to SQLite
Python
209
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