Archive

Archive for the ‘Databases’ Category

Snow Leopard MySQL/PHP problems

August 31st, 2009 Arthur Gressick No comments

After I did a clean install of my system I needed to work on some of my project. I couldn’t get the php websites to work with the Snow Leopard. I had to go into the php.ini (php.ini.default) and edit the file.

nano /etc/php.ini or /etc/php.ini.default

Add in the 3306 for the port.

mysql.default_port = 3306

Categories: 10.6 Workstation, MySQL 5.x Tags: ,

Free Zipcode Database

July 17th, 2009 Arthur Gressick No comments

I am working on a project for looking up distances from zipcodes. I found an open source database and some other information for making this happen. I will post more on this when I get it completed.

http://zips.sourceforge.net/

Also take a look at this site.

http://www.populardata.com/ (you can find the canadian DB from there)

Good luck and I will post a bunch of information on this page when I am finished.

Categories: Databases, PHP Tags: , ,

Ubuntu 9.04 MySQL Server 5.1 Install

May 7th, 2009 Arthur Gressick 3 comments

This one is pretty easy but worth a post. I wanted to get everything moved up to the new MySQL 5.1 server for the new features. I setup a new VM in order to test out. To install the server on a fresh OS

apt-get install mysql-server-5.1