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

Tags

 Laravel  MySQL  sqlite  sqlite3  mysqldump  linux utilites  Laravel Migrations