techouse / Sqlite3 To Mysql
Licence: mit
Transfer data from SQLite to MySQL
Stars: ✭ 79
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Sqlite3 To Mysql
Dbbench
🏋️ dbbench is a simple database benchmarking tool which supports several databases and own scripts
Stars: ✭ 52 (-34.18%)
Mutual labels: mysql, sqlite
Gitauthors
✍️ Get a quick summary of a repo's authors.
Stars: ✭ 50 (-36.71%)
Mutual labels: command-line, tool
Ensembl Hive
EnsEMBL Hive - a system for creating and running pipelines on a distributed compute resource
Stars: ✭ 44 (-44.3%)
Mutual labels: mysql, sqlite
Pastebin Scraper
Live-scraping pastebin to fight boredom.
Stars: ✭ 66 (-16.46%)
Mutual labels: mysql, sqlite
Lucid
A simple mock-application for programs that work with child processes
Stars: ✭ 45 (-43.04%)
Mutual labels: command-line, tool
Phpwpinfo
Provides an equivalent to the `phpinfo()` but with more WordPress requirements details.
Stars: ✭ 52 (-34.18%)
Mutual labels: mysql, tool
Wait4x
Wait4X is a cli tool to wait for everything! It can be wait for a port to open or enter to rquested state.
Stars: ✭ 30 (-62.03%)
Mutual labels: mysql, tool
Warp
Convert and analyze large data sets at light speed, on Mac and iOS.
Stars: ✭ 62 (-21.52%)
Mutual labels: mysql, sqlite
Fsq
A tool for querying the file system with a SQL-like language.
Stars: ✭ 60 (-24.05%)
Mutual labels: command-line, tool
Laravel
Muito conteúdo sobre o framework Laravel. Controllers, Models, Views, Blade, Migrations, Seeders, Middlewares, Autenticação, Autorização, Providers, pacotes, laravel 8, etc.
Stars: ✭ 43 (-45.57%)
Mutual labels: mysql, sqlite
Cloud Security Audit
A command line security audit tool for Amazon Web Services
Stars: ✭ 68 (-13.92%)
Mutual labels: command-line, tool
Iobroker.sql
Store history data in SQL Database: MySQL, PostgreSQL or SQLite
Stars: ✭ 37 (-53.16%)
Mutual labels: mysql, sqlite
Admin
AutoQuery + Admin UI for ServiceStack Projects
Stars: ✭ 47 (-40.51%)
Mutual labels: mysql, sqlite
Hunt Entity
An object-relational mapping (ORM) framework for D language (Similar to JPA / Doctrine), support PostgreSQL and MySQL.
Stars: ✭ 51 (-35.44%)
Mutual labels: mysql, sqlite
Tbls
tbls is a CI-Friendly tool for document a database, written in Go.
Stars: ✭ 940 (+1089.87%)
Mutual labels: mysql, sqlite
Dbmigrations
A library for the creation, management, and installation of schema updates for relational databases.
Stars: ✭ 67 (-15.19%)
Mutual labels: mysql, sqlite
SQLite3 to MySQL
A simple Python tool to transfer data from SQLite 3 to MySQL.
I originally wrote this simple program as a standalone script and published it as a gist as an answer to this Stack Overflow question. Since then quite some people have taken interest in it since it's so simple and effective. Therefore I finally moved my lazy bones and made a GitHub repository 🐙.
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 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.
-d, --mysql-database TEXT MySQL database name [required]
-u, --mysql-user TEXT MySQL user [required]
-p, --mysql-password TEXT MySQL password
-h, --mysql-host TEXT MySQL host. Defaults to localhost.
-P, --mysql-port INTEGER MySQL port. Defaults to 3306.
--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).
-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.
--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.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].