John Sample

Bits and Bytes
posts - 103, comments - 354, trackbacks - 16

New MySQL/MSSQL Installer

Very beta, but it works:

http://www.johnsample.com/misc/geo2/TIGERInstall.05.zip

The downloads point to the new 2004 second edition files.

The parser operates differently for MySQL and MSSQL, so if you want both versions you must re-parse before installing to a new platform.
All the old MSSQL functions should still work with the exception that there is no support for county/state wide searches, I may add them back in with a patch.

The MySql installer does not run the install scripts for you. You must copy and paste it from the last screen into sometihng else, like SQLyog.
You must use the MyISAM engine. It may work in InnoDB, but I let the indexing run for a day when I tried it and it still wasn't finished.
The MyISAM engine does it in about an hour.

The interface DLL will be up within the next day.

 

posted on Monday, September 05, 2005 3:31 PM

Feedback

# re: New MySQL/MSSQL Installer

Now, lets just hope it works on my computer.

Are you considering releasing the source code so that I can make a php version of the installer? The reason I didn't do it already is because I went to the tigerline website and found out that the document explaining the database structure is OVER 300 PAGES! I just couldn't read that much garbage for something so simple. Oh well, ill probably analyze the database after, that should be enough.
9/6/2005 11:32 AM | Happy Day!?

# re: New MySQL/MSSQL Installer

Why would you want a php version of the installer?
9/6/2005 11:39 AM | John Sample

# re: New MySQL/MSSQL Installer

Because that way, you can install it on a server remotely. Did you ever use phpMyAdmin with mySQL?

Is there a way for you to tell me how the raw tigerline files are organized(like: the first column is the address, and the second is ...), what the relationships between the tables are(primary/foreign keys), and the query to find the lat/long of an address?
9/7/2005 11:29 AM | mike

# re: New MySQL/MSSQL Installer

When I try to run the installer it says that I need at least 10 GB of free space. Why the need for so much space to install this?
10/28/2005 11:59 AM | balance

# re: New MySQL/MSSQL Installer

John, thank you very much for your hard work.

I have a queation regarding MySQL installer. Please, correct me if what I express here is wrong.

Assuming that I have www directory on my Linux server, and put all files under www directory.

1. Download Tiger data (.zip) and unzip. Copy it to t1path. Let's say www/TigerData/ directory

2. Copy fips55.txt to FIPSpath. Assume it's a current directory (www).

3. Run MySql commends in MySql.txt by replacing '<tipath>' to 'TigerData/TGRxxxRT1', and '<FIPSPath>' to 'fips55.txt' ** Is it correct? BTW, it seems that we don't have any Load command in MySql.txt to load TGRxxxRT2 data to tiger_02 table. Is it missing, or not needed?

4. Run Geo.all.07.txt
5. Run indices.txt

11/2/2005 2:37 AM | cm

# re: New MySQL/MSSQL Installer

You would definitley have to run the installer on a windows machine first.
The steps would be:

1. Run the installer on a windows machine
2. Let the installer download the census data
3. Select MySql when prompted
4. Let it parse the files (no unzipping necessary)
5. Run the script shown in the last dialog on a linux machine

(Geo.all.07.txt is for sql server, so is indices.txt, you can ignore them)
11/2/2005 7:31 AM | John Sample

# re: New MySQL/MSSQL Installer

Hi John.... This is great work!!! I can't get it running, but I'm so excited about your effort anyway! =)

I have XAMPP installed and am running stuff in locahost... I copied in the Tiger files to ../localhost/Tiger/ and tried to run the installer in my browser and directly...but it errored out with "Failed to initialize properly" ...

Is there any step by step instructions on how to install this? I actually want to install it to a PHP site, but I get the impression I have to install on Windows first... I've read all over the site, but the actual procedure to get this running eludes me...

Any pointers (or links) would be greatly appreciated!

Hoda
11/13/2005 3:25 PM | Hoda May

# re: New MySQL/MSSQL Installer

Hi John..

I have Tiger Install .05 installer and MysQl installed on my machine, but when I try to run Tiger Install.exe, it gives error

" The application failed to initialize properly (0xc0000135). Click on OK to terminate the application"

Pls let me know what is wrong.

Also, I saw the comment by cm dated 11/2/2005 2:37 AM whereby he is trying to run this on unix box. I would like to know how would I make a call to DLL functions in that case.

Looking forward to an early response.

Shilpi
[email protected]
1/11/2006 6:49 AM | Shilpi

# re: New MySQL/MSSQL Installer

hi john.... please healp, how to unstalled the SQL..

i dont know waht to do...

ryn
11/15/2006 1:06 AM | ryn

Post Comment

Title  
Name  
Url
Enter the code you see:
Comment