converting mysql db into sqlite3.

[chun ping wang]

hi, i have a simple problem of opening an existing mysql database with
sqlite3.

Is it possible? (I have an instinct that it is), however i don';t know the
most easiest and straight forward approach to do so. Thanks for the help.

_________________________________________________________________
View Athlete’s Collections with Live Search
http://sportmaps.live.com/index.html?source=hmemailtaglinenov06&FORM=MGAC01

 

[gordyt]

You could probably use the mysqldump command with the proper options to
export the contents of your mysql database to an ASCII text file that
contains the SQL insert statements. Then you could import that
information to a sqlite database file. You may have to massage the
export file if it contains syntax that is not supported by sqlite.

Documentation for the mysqldump command is here:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

The SQL syntax supported by sqlite is here:

http://www.sqlite.org/lang.html

--gordy

 

[skip]

gordy> You could probably use the mysqldump command with the proper
gordy> options to export the contents of your mysql database to an ASCII
gordy> text file that contains the SQL insert statements.

Not sure where the original post is. All I see is this reply.
In case the OP is listening, I believe you can do this in a fairly
straightforward manner with SQLAlchemy.

Skip