How to Import a Website with Database (cPanel Guide)

This guide will help you upload your website files and import the database correctly.

✅ Step 1: Upload Website Files

1. Login to your cPanel account
2. Open File Manager
3. Navigate to:
   • public_html (for main domain)
4. Click Upload
5. Upload your website file (ZIP recommended)
6. After upload:
   • Right-click → Extract

✅ Step 2: Create Database & User

1. Go to MySQL Databases
2. Create:
   • Database Name (e.g. yourdb)
   • Username (e.g. youruser)
   • Strong Password
3. Scroll down → Add User to Database
4. Select:
   • User + Database
   • Click Add
   • Tick ALL PRIVILEGES

✅ Step 3: Import Database

1. Go to phpMyAdmin
2. Select your database (left side)
3. Click Import
4. Choose your .sql file
5. Click Go

✅ Step 4: Connect Website to Database

You must update the config file inside your website.

For WordPress:

Open wp-config.php and edit:

For Custom Websites:

Edit file like config.php or .env:

✅ Step 5: Check Website

Open your domain and confirm:

• Website loads
• No database errors
• Login works

⚠️ Common Issues

❌ Database Connection Error

• Wrong DB credentials
• User not added to database

❌ Website Shows Error / Blank Page

• Check PHP version in cPanel → Select PHP Version
• Check .htaccess file

❌ Links Not Working (WordPress)

• Update:
  • siteurl
  • home
    inside phpMyAdmin → wp_options

Pro Tip (Recommended by Netpoa)

For easier migration:

• Use WordPress plugins like:
  • All-in-One WP Migration
  • UpdraftPlus
• Or request support via: support@netpoa.com