US major cities added to database

I have a script built off of the yii framework. I need the locations added in of all of the major US cities similiar to how craigslist is laid out. I'll give you access to cpanel and have you run the sql through phpmyadmin. Several databases already exist with the data so you should just have to convert the database to the format used by the framework and import the entries