Monday, October 25, 2010

Haversine Formula Calculation between two points

seems like safari does not support torad() function of javascript.

function getDistance(lat1, lon1, lat2, lon2) {

var R = 6371; // km
var dLat = (lat2-lat1) * Math.PI / 180;
var dLon = (lon2-lon1) * Math.PI / 180;
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(lat1 * Math.PI / 180) * Math.cos(lat2 * Math.PI / 180) *
Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

return d.toFixed(2);
}

Friday, October 1, 2010

mysqldump and restore

mysqldump -u [uname] -p [dbname] > bak.sql

mysql -u [uname] -p [dbname] < [bak.sql]