converting mysql db into sqlite3.

gordyt gordyt at gmail.com
Sat Dec 16 15:30:34 EST 2006


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




More information about the Python-list mailing list