A simple Python tool to transfer data from MySQL to SQLite 3
Project description
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 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.
-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
-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.
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mysql-to-sqlite3-1.4.0.tar.gz
(28.1 kB
view hashes)
Built Distribution
Close
Hashes for mysql_to_sqlite3-1.4.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ef08f209d30e2b5bb91054d69333cb218a7966c7a8f9836ce6ae7a8189b1b3ce |
|
MD5 | b07aa3429d81564b1df81d97444bc471 |
|
BLAKE2b-256 | f5dcb711a650a49409e39efa341c2b9f977e563176a78f2083da88591bf997fb |