[ Home ]

Instructions to Import GeoNetMap in MySql

The following article assumes you have already created a database or are planning to import it into an existing database.

1. Copy all the map files into the databases data directory. For example: c:\mysql\data\db_name

2. Download the MySqlGeoNetMapImport.sql script file and save the file to the current directory.

3. Open a MySql command window, and select the target database. ie Use db_name

4. Run the following command

source MySqlGeoNetMapImport.sql;

4. You can run the following query to test whether the importation succeeded:

select city
From Cities c
inner Join Subnets s on s.CityId=c.CityId
Where SubnetAddress='207.71.204';

If the tables are created succesfully but no data is in them, try executing this code here.

Instructions on performing a database update

1. Copy all the updated map files into the databases data directory. For example: c:\mysql\data\db_name

2. Open a MySql command window and select target database. ie Use db_name

3. Download the MySqlGeoNetMapUpdate.sql script file and save the file to the current directory.

4. Run the following command:

source MySqlGeoNetMapUpdate.sql;

Send mail to info@geobytes.com