Uploading databases

If you are switching your hosting to Name.com, you may need to upload databases to your new hosting plan. This is a standard requirement when migrating WordPress sites or other database-driven applications.

Phase 1: Preparation

Before you begin, you must identify the credentials used by your application. If you are migrating a WordPress site, locate and open the wp-config.php file in your site's root directory.

Take note of the following values:

• DB_NAME (Database Name)

• DB_USER (Database Username)

• DB_PASSWORD (Database Password)

Phase 2: Create the database and user in cPanel

1. Log into cPanel and navigate to the Databases section.

2. Click on MySQL Databases.

3. Under Create New Database, enter the database name and click Create Database.

4. Under MySQL Users, enter the username and password, then click Create User.

5. Under Add User To Database, select the correct user and database from the dropdown menus, then click Add.

6. On the Manage User Privileges page, check the box for ALL PRIVILEGES and click Make Changes.

Phase 3: Import the data via phpMyAdmin

1. Return to the main cPanel dashboard and click phpMyAdmin.

2. In the left-hand sidebar, click the database name you just created.

3. Click the Import tab at the top of the page.

4. Click Choose File (or Browse) to locate your .sql file.

5. Scroll to the bottom and click Import (or Go).

Troubleshooting and connection errors

If you encounter issues during or after the upload, check the following:

• File Extensions: If an upload fails, ensure your file ends in .sql. If your file is named user_test, rename it to test.sql.

• Database Prefixes: In cPanel, database names and usernames are usually prefixed with your cPanel account name (e.g., account_dbname). You must update your wp-config.php file to include these full prefixed names to avoid "Error Establishing a Database Connection."

• Password Mismatch: Ensure the password you entered in cPanel exactly matches the password listed in your wp-config.php file.

Note: Ensure all migrated content adheres to the Name.com Acceptable Use Policy. It is highly recommended to keep a local backup of your database before performing any import operations.