Category MySQL

PHP – GPS Tracks In Google KML Format

Amongst other things, I have the habit of keeping a detailed track of where I have been and for this purpose, I use my Garmin GPSMap 60CSx. I have configured this GPS to save track information every 3 seconds. If…

Importing Geonames.org Data Into MySQL

What is Geonames.org, you wonder? It’s a website [or an web-institution, if you like to phrase it that way] that provides – amongst other things – [pretty] useful information that maps geological data [country, region, city/town/village, etc.] to the GPS…

PHP – Storing GPS Track Points In MySQL

Though the term waypoint has come into fairly common use in recent times, the concept has existed for as long as we have been navigating. Waypoints have traditionally been associated with distinctive features of the physical world – such as…

PHP – Storing GPS Waypoints In MySQL

Though the term waypoint has come into fairly common use in recent times, the concept has existed for as long as we have been navigating. Waypoints have traditionally been associated with distinctive features of the physical world – such as…

WordPress – Posts As News Clips Elsewhere

Disclaimer The instructions/steps given below worked for me running CentOS. It may very well work for you on other linux distributions, Red Hat-like or otherwise. Please note that if you decide to use these instructions on your machine, you are…

Storing And Querying Information with PERL-MySQL

Disclaimer These instructions/steps worked for me and it may very well work for you on Sun OS / linux distributions. Please note that if you decide to use these instructions on your machine (either for this particular application and/or for…

Importing Comments From flickr.com

Disclaimer These instructions/steps worked for me in CentOS 4.0. It may very well work for you on Red Hat-like or other distributions. Please note that if you decide to use these instructions on your machine, you are doing so entirely…

PHP, MySQL, iCal, ICS

Disclaimer These instructions/steps worked for me in CentOS and MacBook Pro. It may very well work for you on Red Hat-like or other and Macintosh distributions. Please note that if you decide to use these instructions on your machine, you…

Backing Up And Restoring MySQL Databases

Disclaimer These instructions worked for me in CentOS 4.0. It may very well work for you on Red Hat-like or other distributions. Please note that if you decide to use these instructions to back up and restore MySQL databases on…

CentOS 4.x : Upgrading PHP and MySQL

Disclaimer These instructions worked for me in CentOS 4.0. It may very well work for you on Red Hat-like or other distributions. Please note that if you decide to use these instructions, you are doing so entirely at your very…