Mysql – Exporting data from Mysql into Sqlite

MySQLsqlite

i want to export from mysql into sqlite. currently i can export from mysql into a dump file. the only problem is importing to a sqlite db. the import feature on sqlite does not currently support the dump from mysql. is there any other way.

Best Answer

Yes, there is a way, it's a very cool AWK script, which just needs the MySQL dump. Find it here - https://github.com/dumblob/mysql2sqlite

Related Solutions

Mysql – Exporting/Importing a large MySQL database without thesqldump

I was having the same problem, solved with Percona Xtrabackup. It's free, faster and consistent.

Directly import a csv gzip’ed file into SQLite 3

I found that sqlite3 custom init script can have meta-command as well as SQL statement:

#!/bin/sh

commandfile=$(mktemp)

# create temporary init script
cat <<EOF > $commandfile
.mode csv tablename
.import /dev/stdin tablename
EOF

# import
bzip2 -d -c huge_compressed.csv.bz2 | sqlite3 --init $commandfile dbname.db

Best Answer

Related Solutions

Mysql – Exporting/Importing a large MySQL database without thesqldump

Directly import a csv gzip’ed file into SQLite 3

Related Question