USA Cities and States mysql Dump

By David | July 14, 2008 | Home | Blog Categories | Helpful Resources

This mysql category dump is for phpLD 3.3 and creates a category structure for the cities and states in the USA. There 7,682 cities and states listed, meaning the database covers most cities and towns, but it some of the smaller towns have been left own. The problem with displaying every town and city in the USA is state pages can become bloated with too many subcategories making the pages slow to load and not very user friendly. With this database, pages should load fine, and all but the very small towns are listed.

Download Now

This dump should only be used on a fresh installation of phpLD. After installation, in phpMyAdmin you can delete the existing pld_category and pld_category_seq tables and then replace it with these. If your host has the time out set too low, you may need to use a free tool called big dump. Some understanding of using phpMyAdmin is needed. If you have trouble, this is something that an experienced programmer could do in just a few minutes.

« Back to Helpful Resources
Previouse article: Multi Directory Link Checker
Next article: phpLD Category Dump

Publish date: July 14, 2008
Printer version    
Available downloads

Support Our Sponsors

Posts by Category

   categories Articles
   categories Development Blog
   categories Helpful Resources
   categories Mods
   categories News
   categories Spotlight on Great Directories
   categories Templates
   categories Tutorials


A great prize awaits if you use our recommended host. Take a look at our special offer to find out how you can get our product virtually free. or receive other benefits. We also have a recommended hosts page, and we give you credits such as our product just for signing up with them.