xt" ".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
What OS are you using? There is a freeware utility here for Windows:
http://sqlite2009pro.azurewebsites.net/
Thanks,
Chris
On Sat, Sep 10, 2016 at 10:24 PM, Scott Doctor
wrote:
> I have a database with a few tables and about 140MB of data in it that
> exists as a MySQL database. Using MySQL w
The database evolved over the past ten years with many
modifications over time. I decided to just do it the hard way.
Created the schema from scratch in sqlite, exported each table
as csv from mysql (22 of them). Mysql workbench only exports to
csv at the table level, not at the database level.
On 10 Sep 2016, at 10:24pm, Scott Doctor wrote:
> Anyone know of a utility to directly convert from MySQL to sqlite?
What syntax does the SQL dump use that the SQLite command-line shell doesn't
like ?
I generally do this stuff using find/replace in a text processor (TextEdit on
the Mac, NOTE
On Sat, 10 Sep 2016 14:24:48 -0700
Scott Doctor wrote:
> 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
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
6 matches
Mail list logo