Tag Archives: importing

Importing to Piwigo

Piwigo is pretty good! I mean, I mostly use Flickr at the moment, because it is quick, easy to recommend to people, and allows photos to be added to Trove. But I’d rather host things myself. Far easier for backups, … Continue reading

Posted in Open content | Tagged , , , , , , | Leave a comment

Loading spatial data into MySQL with LOAD DATA INFILE

Just a note for my future reference: importing an Excel CSV into MySQL. The WKT column has been constructed by hand to be POINT(lng lat) and the CSV contains headers. LOAD DATA INFILE ‘/full_path/to/file-on-server.csv’ REPLACE INTO TABLE the_table COLUMNS TERMINATED … Continue reading

Posted in Programming | Tagged , , , , , , , , | Leave a comment