WordPress SQLite to MySQL Migration Complete
Leave a reply
Just finished migrating my website from SQLite to MySQL. What a rush. (lol)
It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL.
Some quick commands I used:
sqlite techish.db .dump > production_2018-08-23.dump.sql
I found that it used quotes for tables and column names, so I had to remove those first and foremost.
sed -i '/INSERT INTO/,/VALUES (/s/"//g' production_2018-08-23.dump.sql
Next Continue reading →