Copy MySQL Database to SQLite (Table Structure Already Created)


 AMP
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: https://stackoverflow.com/a/36350631



Comments:


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...