Meta tags:

Headings (most frequently used words):

geonetmap, to, the, geobytes, how, install, and, maintain, on, lamp, linux, apache, mysql, php, because, everybody, somewhere, use, paypal, button, in, right, margin, start, your, subscription, today,

Text of the page (most frequently used words):
the (40), you (20), your (16), geobytes (13), and (13), database (12), that (11), then (10), geonetmap (9), access (8), will (8), our (7), map (7), for (6), city (6), echo (6), data (6), #script (6), server (6), cities (5), not (5), query (5), join (5), code (5), use (5), create (5), via (5), this (5), files (5), line (4), regionid (4), countryid (4), with (4), download (4), check (4), installation (4), are (4), mysql (4), install (4), need (4), tar (4), have (4), following (4), password (3), search (3), vip (3), lamp (3), api (3), location (3), result (3), link (3), die (3), select (3), sql (3), from (3), here (3), view (3), table (3), http (3), zip (3), key (3), once (3), has (3), php (3), cron (3), job (3), provider (3), command (3), geonetmaploader (3), directory (3), address (3), subscription (3), file (3), faq (2), where (2), calculator (2), get (2), geo (2), free (2), col_value (2), subnetaddress (2), ipaddress (2), could (2), mysql_error (2), country (2), cityid (2), regions (2), countries (2), html (2), how (2), my_db (2), locationcodes (2), concat (2), latitude (2), longitude (2), finally (2), locator (2), page (2), name (2), com (2), alternatively (2), want (2), raw (2), into (2), able (2), queries (2), there (2), prompt (2), local (2), tables (2), upon (2), any (2), hosting (2), may (2), cpanel (2), equivalent (2), facility (2), note (2), run (2), session (2), archive (2), shell (2), instructions (2), ssh (2), step (2), each (2), process (2), linux (2), apache (2), dedicated (2), information (2), contains (2), one (2), proudly, powered, wordpress, remember, username, status, storage, cost, solution, nearby, details, geoworldmap, geoif, geodirection, georemote, tags, headers, templates, geophrase, geoflag, moving, ajax, autocomplete, list, json, apis, because, everybody, somewhere, mapversion, resultset, mysql_free_result, closing, connection, mysql_close, while, mysql_fetch_array, mysql_assoc, foreach, connecting, selecting, mysql_connect, server_name, user_name, connect, mysql_select_db, performing, region, subnets, print, mysql_query, failed, printing, results, connected, successfully, working, example, shows, drop, exists, internet, locationcode, fullcityname, creates, virtual, containing, codes, see, along, fully, qualified, just, out, before, importing, above, find, lower, part, account, land, after, logging, can, directly, using, follows, completed, embedded, some, sample, implementation, guide, user, should, required, import, completion, importation, was, successful, configured, execute, per, day, updates, restricted, crontab, manually, called, install_update, mkdir, curl, downloads, xvf, established, empty, perhaps, home, extract, contents, commands, enter, them, assume, don, know, what, means, company, they, probably, recommend, something, like, putty, establish, still, complete, steps, but, unfortunately, unable, provide, facilities, different, case, research, documentation, possibly, seek, their, assistance, chiark, greenend, org, sgtatham, nload, automated, installing, maintaining, instance, environment, work, both, shared, environments, maintain, paypal, button, right, margin, start, today, technology, behind, been, developed, dependent, provided, site, visitor, does, cookies, dns, look, ups, whois, distributed, set, eight, text, necessary, populate, relational, management, system, when, downloaded, delivered, two, separate, seven, these, relatively, small, change, more, frequently, than, other, single, summarizes, distribution, across, source, service, provides, full, standard, allows, machine, configuration, facilitates, direct, own, rdms, such, located, servers, third, party, buy, now, einstein, agent, services, simple, solutions, distance, tool, skip, content, primary, menu,

Text of the page (random words):
geonetmap geobytes geobytes search primary menu skip to content city distance tool ip address locator simple solutions free services einstein s agent buy now search for geonetmap our standard geonetmap subscription allows you to install our map database on your machine this configuration facilitates direct access to our map database via your own rdms such as mysql or ms sql server there is no need for co located or dedicated geo servers or third party api s geobytes geonetmap subscription service provides full access to our ip address to location database the geobytes map is distributed as a set of eight text files each file contains the information necessary to populate one table in the relational database management system when downloaded from geobytes the map data is delivered as two separate zip files one zip file contains seven of the files these files are relatively small and change more frequently than the other single file the following table summarizes the distribution of data across the source files mapversion the technology behind this has been developed by geobytes and is not dependent upon any information provided by your site visitor it does not use cookies dns look ups or whois data use the paypal button in the right margin to start your subscription today how to install and maintain geonetmap on lamp linux apache mysql php we have automated the process of installing and maintaining an instance of our ip address map database database geonetmap in a lamp linux apache mysql php environment the following process will work on both shared and dedicated server environments note the following instructions assume that you have ssh access to your server if you don t know what that means then check your hosting company s faq they will probably recommend that you use something like putty http chiark greenend org uk sgtatham nload html to establish a ssh session with your server if you do not have shell access then you may still be able to complete the following steps via cpanel or an equivalent facility but unfortunately i am unable to provide you with step by step instructions to do this as each provider s facilities are different in this case you will need to research you local provider s documentation and possibly seek their assistance once you have established a command line session with your server then download the installation archive into an empty directory on your server perhaps create a geobytes directory in your home directory then extract the contents of the archive and then finally run the installation script here are the commands to do this you need to enter them at a command shell prompt mkdir geobytes cd geobytes curl http geobytes com downloads geonetmaploader tar geonetmaploader tar tar xvf geonetmaploader tar install sh the installation script will then prompt you for the database name user and password that it should use for access to your local mysql database the script will then create the required tables in the database and import the raw data in to the tables upon completion it will check that the importation was successful and will create a cron job that is configured to execute once per day and check for and install any map updates if your hosting provider has restricted command line access to crontab then you may need to create the cron job manually via cpanel or an equivalent facility note the script that you want the cron job to run is called install_update sh once the installation script has completed then you will be able to access the data via embedded sql queries in your php code there are some sample queries in our geonetmap implementation guide alternatively if you just want to download the raw data to check it out before importing it into your database via the above script then you ll find the download link on the lower part of the my account page that you land on after logging in or alternatively you can download it directly using your vip key as follows http gd geobytes com map zip key your vip key finally here is a view that creates a virtual table containing the geobytes location codes that you see on our ip locator page along with a cities fully qualified city name drop view if exists my_db locationcodes create view my_db locationcodes as select concat co internet r code c code as locationcode concat c city r code co country as fullcityname c latitude as latitude c longitude as longitude from cities c join regions r on r regionid c regionid join countries co on co countryid r countryid and here is a working code example that shows how to use it subnetaddress ipaddress connecting selecting database link mysql_connect server_name user_name password or die could not connect mysql_error echo connected successfully mysql_select_db geonetmap or die could not select database performing sql query query select c city r region co country from cities as c join subnets as s on c cityid s cityid join regions as r on c regionid r regionid join countries as co on c countryid co countryid where s subnetaddress ipaddress print query result mysql_query query or die query failed mysql_error printing results in html echo n while line mysql_fetch_array result mysql_assoc echo t n foreach line as col_value echo tt col_value n echo t n echo n free resultset mysql_free_result result closing connection mysql_close link because everybody s somewhere geobytes ip location apis ajax autocomplete list cities json p api city moving calculator geophrase geoflag templates geo tags headers georemote geodirection geonetmap geoif geoworldmap get city details get nearby cities api lamp solution storage cost calculator vip access where am i faq search for status username password remember me proudly powered by wordpress