sqlite3-to-mysql
sqlite3-to-mysql copied to clipboard
techouse
Transfer data from SQLite to MySQL
**Describe the bug** I have a sqlite file with this table: ```sql CREATE TABLE IF NOT EXISTS "credentials_entity" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(128) NOT NULL, "data"...
**Is your feature request related to a problem? Please describe.** See #39 **Describe the solution you'd like** The user may create the table by its own to the targetted mysql...
**Describe the bug** range of int in MYSQL - -2147483648 to 2147483647 range of int in Sqlite - -9223372036854775808 to +9223372036854775807 Value in source DB - 10010000000000001 got value in...
**Describe the bug** For few random tables tool has added auto increment values some tables with value 4, sometable with value 2 and for some tables didn't add and auto...
**Describe the bug** find output ```sh Unable to find image 'ghcr.io/techouse/sqlite3-to-mysql:latest' locally latest: Pulling from techouse/sqlite3-to-mysql 661ff4d9561e: Already exists 44cda88cd45d: Pull complete 8d184ace8e99: Pull complete fbcb6e47dc5d: Pull complete 8dc42379c8ec: Pull...
sqlite3 supports datetime fields but they were being ignored. They might have 32bit or 64bit epoch numbers, which I've converted down to 32bit for mysql compatibility.
Along with the --ignore-errors flag I also implemented a couple of other minor fixes. In the end it led to the fact that only 4 errors (due to bad design...
**Describe the bug** MySQL failed adding foreign key to attendance.link_to_member referencing member.None: 1170 (42000): BLOB/TEXT column 'link_to_member' used in key specification without a key length Traceback (most recent call last)...
In case of SQL errors, I would like to skip this table and move on to the next table. This might end in a corrupt database, but it's sometimes easier...