Shaun Walbridge scw

scw / sailwx-to-postgres.sh

Created April 8, 2012 08:39

Approximate steps for performing a MySQL to PostgreSQL conversion and PostGIS set up

	# Configure Postgres
	#

	# create a postgres database for the records
	createdb sailwx

	# make the new database PostGIS compatible (here, against Postgres 8.4)
	git clone https://github.com/straup/postgis-tools
	cd postgis-tools
	sh ./createdb-8.4.sh sailwx sailwx

scw / gist:1829955

Created February 14, 2012 20:22

example shell loop

	#!/usr/bin/env bash

	for file in `find . -name "*.env"`; do

	# we want the name without the '.env' bit
	base=`basename $file .env`
	echo $base
	done