It’s been a while. And I forgot exact steps. So I had to review by looking at my SQLite notes. In addition to the data (from my, mySQL database on my remote web server) I like to keep a local SQLite version on my computer. I have some useful views that allow me to easily query the database. Especially with SQLite’s builtin date routines. So here are the key steps.
- Export the data on the remote server, using phpMyAdmin, as a CSV using “|” as a seperator, use .txt for extention on save
- From SQLite:
- define the table if necessary
- .separator |
- .import Birthday.txt Birthday [.import much faster than .read]