How To Import Database To Hawkhost

If you’ve moved a website to Hawkhost (or you’re rebuilding one locally and need it live), one of the first tasks you’ll likely face is getting your database uploaded correctly. A database import can bring back your posts, pages, users, settings, and more—essentially restoring the site to the state you had before.

The process is usually straightforward, but the exact steps depend on the database type (most commonly MySQL/MariaDB) and where your database backup came from (a .sql file, compressed archive, etc.). Below is a practical, no-fluff walkthrough you can follow.

Before you start: what you need

Before importing, gather these essentials:

A database backup file, typically:
- .sql (plain SQL dump)
- .sql.gz or .zip (compressed SQL dump)
Your Hawkhost database credentials, including:
- Hostname (often localhost or a remote host)
- Username
- Password
- Database name
Server-side access method, usually one of:
- cPanel (most common)
- phpMyAdmin (often available inside cPanel)
- A database tool like Adminer (sometimes used)

Tip: If you’re missing credentials, log into your Hawkhost account and open your hosting control panel to find the database details. If you don’t have a database created yet, you’ll want to create one first.

Step-by-step: import a database using cPanel / phpMyAdmin

Most Hawkhost customers will handle imports through cPanel → phpMyAdmin. This is the most common route, especially for WordPress sites.

1) Log in to your hosting panel

Go to your Hawkhost client area.
Open your hosting account’s cPanel (or the equivalent control panel).
Find the phpMyAdmin icon.

2) Select the correct database

Inside phpMyAdmin:

Click the database from the left sidebar (if you see a list).
If you created the database already, choose the correct one.
If the database doesn’t exist, create it first:
- In cPanel, look for MySQL Databases and create a database, then add a user and privileges.

3) Import the `.sql` file

Now do the actual import:

With the correct database selected, click the Import tab.
Under File to import, choose your .sql file.
- If your backup is compressed (like .gz), you may need to decompress it first depending on server limits.
Check the options:
- Often you can leave default settings.
- If you see options like character set, choose UTF-8 if your content is multilingual.
Click Go (or Import).

4) Wait for completion and verify results

After the import finishes:

You should see a success message (or a completion summary).
Open phpMyAdmin and check whether tables appear in the left sidebar.
A quick test is to click one or two tables and confirm the data looks right.

If your import file is large, the request may time out. In that case, using the command-line method (below) is usually more reliable.

Command-line import (useful for large backups)

If your backup is big or phpMyAdmin times out, importing via SSH is often the best option. Hawkhost typically supports SSH access through cPanel or your account dashboard.

1) Connect via SSH

In cPanel, find SSH Access or Terminal (depending on what’s offered).
Log in using your SSH username and password or SSH key.

2) Import the SQL file

The common approach is:

mysql -u DB_USERNAME -p DB_NAME < backup.sql

Replace DB_USERNAME, DB_NAME, and backup.sql with your details.
You’ll be prompted for the database password.

If the file is compressed:

gunzip < backup.sql.gz | mysql -u DB_USERNAME -p DB_NAME

zcat backup.sql.gz | mysql -u DB_USERNAME -p DB_NAME

3) Confirm the import

Run:

mysql -u DB_USERNAME -p -e "SHOW TABLES;"

This confirms your tables were created.

Guide: update your site to use the imported database

Importing the database alone may not be enough. Many sites (especially WordPress) also require configuration updates so they point to the correct database.

For WordPress

After importing your database:

Ensure the wp-config.php file has the correct database settings:
- DB_NAME
- DB_USER
- DB_PASSWORD
- DB_HOST
If you moved domains or changed URLs, you might need to update the site URL:
- You can update these in the database directly (in tables like wp_options), or use a plugin/tool designed for this.
If things look broken after import, check for “Error establishing a database connection” first—this usually means credentials are wrong.

For other PHP applications

Look for configuration files such as:

config.php
.env
settings.php

Update the database host/user/name and password to match the Hawkhost database.

Common issues and quick fixes

1) “Access denied” errors

This usually indicates the database user doesn’t have permission or you’re using the wrong user. Re-check the credentials in:

Hawkhost control panel → databases
Your app’s config file

2) Character encoding problems (garbled text)

If your import includes non-English characters and they appear corrupted:

Make sure the backup uses UTF-8
In phpMyAdmin import settings, check character set options
You may also need to adjust database collation

3) Timeouts during phpMyAdmin import

If imports fail halfway:

Try splitting the .sql into smaller files (not always practical)
Use SSH command-line import instead
Compress/uncompress carefully based on server limits

4) Conflicts from existing tables

If you import into a database that already contains tables:

Some setups overwrite data, others error out.
In phpMyAdmin, you might need to drop tables first (be cautious—this deletes existing content).
If you’re moving to a fresh database, it’s usually cleaner to create a new empty database before importing.

Pros / Cons

Pros

Restores your site quickly by bringing back the database contents.
Works for most hosting setups using cPanel/phpMyAdmin.
Command-line import is reliable for large databases and can avoid GUI timeouts.
Great for migrations—you can move between environments with less manual rebuilding.

Cons

Large SQL files may fail in phpMyAdmin due to timeouts or memory limits.
You still need to update configuration files (DB credentials and sometimes URLs).
Accidentally importing into the wrong database can break the site or overwrite data.
Encoding issues can occur if character sets aren’t handled properly.

Wrap-up: choose the right import method

To import a database to Hawkhost, start with the simplest approach: cPanel → phpMyAdmin → Import. It’s fast for typical backups and easy for beginners.

If your .sql file is large or phpMyAdmin repeatedly fails, use the SSH command-line method with the mysql import command. After importing, don’t forget to confirm tables exist and update your application’s database connection details so your website can actually use the imported data.

If you tell me what platform you’re restoring (WordPress, custom PHP app, etc.) and the type of backup you have (.sql or .sql.gz), I can tailor the steps more precisely to your situation.

👉 Sign Up Now