# Quick Start - Bangladesh Location Data Import

## 🚀 Fastest Way to Import

### Option 1: Node.js Script (Easiest)

```bash
cd backend
node database/import_bangladesh_locations.js
```

That's it! Script automatically:
- ✅ Connects to database
- ✅ Reads SQL file
- ✅ Imports all data
- ✅ Shows verification counts

### Option 2: Direct MySQL

```bash
cd backend/database
mysql -u root -p cms_db < insert_bangladesh_locations.sql
```

## 📊 What Gets Imported

- **1 Country**: Bangladesh
- **8 Divisions**: All divisions of Bangladesh
- **64 Districts**: All districts
- **200+ Thanas**: Major thanas for all districts

## ✅ Verify Import

After import, check in your application:
1. Go to **Management** page
2. Click **Location Management** tab
3. You should see all divisions, districts, and thanas

Or check database:
```sql
SELECT COUNT(*) FROM countries;    -- Should be 1
SELECT COUNT(*) FROM divisions;     -- Should be 8
SELECT COUNT(*) FROM districts;     -- Should be 64
SELECT COUNT(*) FROM thanas;        -- Should be 200+
```

## ⚠️ Troubleshooting

**Problem**: "Table doesn't exist"
**Solution**: Run `migration_add_locations.sql` first

**Problem**: "Access denied"
**Solution**: Check database credentials in the script

**Problem**: "Duplicate entry"
**Solution**: This is OK - script handles duplicates automatically

---

**Need Help?** See `BANGLADESH_LOCATIONS_README.md` for detailed guide.

