--------------
SELECT version()
--------------

+------------------+
| version()        |
+------------------+
| 5.1.50-community |
+------------------+
1 row in set (0.00 sec)

--------------
ALTER TABLE tblGeoStateCA
      ADD INDEX (frequency_assigned),
      ADD INDEX (call_sign),
      ADD INDEX (radio_service_code),
      ADD INDEX (class_station_code),
      ADD INDEX (location_county),
      ADD INDEX (location_city),
      ADD INDEX (location_address),
      ADD INDEX (entity_name),
      ADD INDEX (control_county)
--------------

Query OK, 1900594 rows affected (2 min 6.86 sec)
Records: 1900594  Duplicates: 0  Warnings: 0

Bye