This is how I did it:
- Download timezone information by cities from this site: http://citytimezones.info/cms/pending_requests.htm (this example uses the CSV format - download that file)
- Unzip the file and note the location (full path) of the "cities.txt" file.
- Use the following SQL to create a table to hold the data:
- Adapt and run the following SQL statement in MySQL to load the data:
Make sure that when you run the LOAD DATA query, that there are no errors or warnings.
Note that I did not optimize the design of the table (field sizes) to match the data ( DIY )