Funny, I was just doing the same thing.
I have hacked together some Python code to convert the MySQL exports from the
Workbench into SQLite format for import.
It's not pretty, and is a work in progress, but you are welcome to it.
Uncheck everything from the advanced tab and select Dump Structure and
Data. This will not convert triggers and only converts a few functions but is
easy enough to manipulate to do what you need.
https://drive.google.com/open?id=0B_3LcLJUnNA4MVozYWtUaGZFbUk
Once converted run: SQLITE3 OuputName.sqlite ".log log.txt" ".read
InputFromConversion.sql"
Hope it helps.
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Scott Doctor
Sent: Saturday, September 10, 2016 4:25 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Convert mysql to sqlite
I have a database with a few tables and about 140MB of data in it that exists
as a MySQL database. Using MySQL workbench I can export the data, but it dumps
as a SQL dump with its flavor of sql. I want to convert this database into a
sqlite database.
Nothing fancy in it. No triggers, procedures, or foreign keys.
Tables are normal structure with a pk field and some text and integer fields in
each table.
Anyone know of a utility to directly convert from MySQL to sqlite?
--
-------------------------
Scott Doctor
sc...@scottdoctor.com
-------------------------
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
This communication is the property of CenturyLink and may contain confidential
or privileged information. Unauthorized use of this communication is strictly
prohibited and may be unlawful. If you have received this communication in
error, please immediately notify the sender by reply e-mail and destroy all
copies of the communication and any attachments.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
