MySQL normalized and ready-to-use tables of Countries, Regions (Provinces/States), Cities
Installation
The SQL file includes create statements with indexes, so simply follow the steps below to import the sql file.
Linux/OSX command line:
$ gunzip world.sql.gz
$ mysql -u myusername -p mypassword
mysql> use mydatabase;
mysql> source world.sql;
Windows
- Install 7zip (so you can extract gzip files)
- Extract world.sql.gz and then use the same mysql command lines as Linux above on the
world.sqlfile
Data Structure
Countries table
- Size (uncompressed, in database w/ indexes): 32 KB
- 230 records