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