Step 3: Create Tables

 Top  Previous  Next

 

Create your MySQL database tables:

 

During Step 3 of the installation, install will connect to your MySQL database and issue commands to create all the necessary tables.  Once the tables are created, each table will be filled with default system data.

 

It may take several minutes to process this step.

 

Note: This step will erase all existing data in your tables if you are reinstalling.  There is a link to Skip This Step on the page.  Only skip Step 3, if you are reinstalling the software and you are 100% positive that your database already has your tables created and all the installation data inserted from a previous install.  Never Skip this step if you are installing for the first time.

 

 

Table Creation:

 

The following tables will be created during this step:

 

Table Name:

Description:

location

Used to store all the location data

login

Used to store the admin login info

listcountry

Used to store country names and codes

zipcode

Used to store the official zip codes and their lat and long coordinates

setfield

Used to store database field information

list1

Used to store United States state names

limitsearches

Used to store Limit Search by IP settings

hitcounter

Used to store IP and time stamps of your visitors

 

 

Fill Tables:

 

After a table is created, the installation will insert default installation data into the tables.  This installation data is needed to run your locator system.  It includes data such as Country Codes, State Codes, Zip Codes, Latitude/Longitude Coordinates, etc...

 

The installation will also locate the usa_zipcodes.txt file that you uploaded to your server, in the root installation directory.  This file contains over 42,000 records for the United States zip codes along with corresponding latitude and longitude coordinates.

 

Results Screen:

 

If Step 3 is successful, you will be presented with a list of table names and their success status.