Copy MySQL Database to SQLite (Table Structure Already Created)

mysqldump -u root {database} {table} --no-create-info --skip-extended-insert --complete-insert --skip-add-locks --compatible=ansi | sed "s/\\\'/''/g" | sqlite3 database.sqlite

From SA:


Gravatar of Kyle Jones

Knowledge Base is a repository for various notes, guides, and thoughts on a wide range of IT related topics. Read more...

Sponsored By:

Web development services by Say Web Solutions. Visit website.