# ⚡ QUICK REFERENCE: cPanel Migration

## Your New Database Credentials
```
Database: mahamusa_db
User: mahamusa
Password: tCG!c&lpxW8Q
Host: localhost
```

## 3-Step Export Process

### Step 1: Export Database (Local)
- Open: http://localhost/phpmyadmin
- Select database: "login-table"
- Click: "Export" tab
- Choose: "Custom" format
- Click: "Go"
- Save file as: `database_backup.sql`

### Step 2: Create in cPanel
- Login to cPanel
- MySQL Databases → Create database: `mahamusa_db`
- MySQL Users → Create user `mahamusa` with password `tCG!c&lpxW8Q`
- Add user to database with ALL privileges

### Step 3: Import to cPanel
- cPanel → phpMyAdmin
- Select: `mahamusa_db`
- Click: "Import" tab
- Upload: `database_backup.sql`
- Click: "Import"

## Upload Website

Via File Manager:
1. Zip your `ecoms` folder
2. Upload to cPanel public_html
3. Extract zip file
4. Delete zip file

Via FTP:
1. Get FTP credentials from cPanel
2. Use FileZilla or WinSCP
3. Connect and upload files to public_html/ecoms

## Test Your Site
- Visit: your-domain.com/ecoms
- Check homepage loads
- Check admin login
- Test database queries

## If You Get Errors

| Error | Solution |
|-------|----------|
| Connection refused | Check database user privileges |
| Access denied | Verify password is correct |
| Unknown database | Create database in cPanel |
| Files not found | Upload to public_html/ecoms folder |

## Files Already Updated ✅
- db_config.php
- admin_seo_manager.php
- debug_seo_load.php
- seo_status.php
- test_seo_debug.php

**No need to manually update PHP files - all done!**

## Important ⚠️

cPanel might show database names like:
- `username_mahamusa_db` (instead of `mahamusa_db`)
- `username_mahamusa` (instead of `mahamusa`)

This is normal. Just use what cPanel assigns.

## Support Files
- See: CPANEL_MIGRATION_GUIDE.md (detailed steps)
- See: CPANEL_DEPLOYMENT_README.txt (overview)
