IP2Country Database - Easily import IP2Country database into MySQL

IP geolocation Database Products
· IP-Country Database
· IP-Country-Region
· IP-Country-Region-City
· IP-Country-ISP Database
· IP-Country-Region-City-ISP
· Target Country by IP Address · Analyse Spider

IP Address Country Database FAQ F.A.Q.
Purchase IP2Country Database Purchase
Downloads Downloads
IP2Country Database - Technical Details Technical Details
Contact us Contact us

IP Address Locator
IP Geolocation Articles & Tutorial (Free)

  IP2Country Database   Import IP2Country database into MySQL  

Easily Importing IP2Country MySQL dump file into MySQL

This article explains how to move dump file contents to MySQL server using the most popular tools.

1. MySQL console client (mysql)
Syntax of the command line depends on the structure of the dump file. If the dump file contains 'CREATE DATABASE' statement you should call MySQL console client as follows:

mysql --host=... --user=... --password=... -vvf < dump_file_name

Otherwise:

mysql --host=... --user=... --password=... -vvf MySQL_database_name < dump_file_name

where 'MySQL_database_name' is a name of an existing database.

2. phpMyAdmin
Note, that phpMyAdmin allows to import dump file into an existing MySQL database only, so the dump file should not contain 'CREATE DATABASE' statement.

Step 1. Click on the appropriate database name in the left frame.

Step 2. Click 'SQL' tab on the top of the screen.

Step 3. Enter full path to the dump file in 'Location of the textfile' field or click 'Browse' button to locate it through the directory tree.

Step 4. Click 'Go' button.


Copyright ©2001-2013 Jgsoft Associates. All rights reserved.