mysql2sqlite
mysql2sqlite copied to clipboard
dumblob
Converts MySQL dump to SQLite3 compatible dump
`mawk` does not support brace expressions for repetition. See: https://github.com/ThomasDickey/original-mawk/issues/25 This change works around the problem by just repeating the match group the desired number of times. You can see...
According to https://www.gnu.org/software/gawk/manual/html_node/Escape-Sequences.html the `"` need only be escaped as `\"` in string constants. I suspect from [googling](https://www.google.com/search?&q=gawk+5+"regexp+escape+sequence"+"is+not+a+known") (though cannot confirm) that in gawk 5.0+ this escaping causes a warning....
The Regex has been changed from > / ENGINE| engine/ to > / ENGINE| engine| \\);/ This way, when the "ENGINE" keyword isn't present, it will still print out the...
When I run this command:`table lineorder has 2 columns but 17 values were supplied` I have this error: ` Error: near line 60: table lineorder has 2 columns but 17...
This is valid sqlite and mysql syntax. These drop table statements should be preserved.
Firstly, thanks for this great script 👍 We have a database that after running the `mysqldump` output through this script, we are left with a part of the SQL dump...
I'm working on a project which uses your MySQL to SQLite conversion script as our application currently uses sqlite but we plan on switching to MySQL in the future, so...
This script seems to work very well for my needs except for the fact that it isn't generating views. My database only has one view, and it's part of my...
Given the following DDL: ```sql CREATE TABLE "foo1" ( "col1" varchar(255), KEY "key1" ("x"), CONSTRAINT "constraint1" FOREIGN KEY ("fk1") REFERENCES "foo2" ("col2") ); ``` mysql2sqlite emits (1) a malformed CREATE...
