The states or provinces of India are not present by default in Magento 1.7 or older versions. If you want to include the states or territories in the checkout process or during registration, you will need to do it manually using SQL (phpMyAdmin). It’s an easy task taking less than a second to complete.
Note: Before continuing backup the database first, in case anything untoward happens, we can easily revert back.So here are the steps to include States or Provinces of India Inside Magento 1.7 or below:
1. Login to the Cpanel and go to phpMyAdmin
2. Select the database in which your magento installation is running.
3. Go to SQL.