How to import an existing MySQL database into cPanel

steps to import an existing MySQL database into cPanel at dotCanada.com:

1. Log into your dotCanada.com cPanel account.

2. In the "Databases" section, click on the "MySQL Databases" icon.

3. Scroll down to the "Upload a Database" section and click on the "Browse" button to select the SQL file containing your database backup from your local computer.

4. Once the file is selected, choose the appropriate options:

• Collation: Select the character set for your database

• Database Name: Enter a name for your new database

• Overwrite Existing Database: Check this box if you want to overwrite an existing database with the same name

5. Click on the "Upload" button to begin the import process.

6. dotCanada.com will now upload and import your database. This may take some time depending on the size of your database file.

7. Once the import is complete, you will see a success message. You can now access and manage your imported database through the "MySQL Databases" interface in cPanel.

Additional Tips:

• Ensure that your SQL file is properly formatted and does not contain any errors.

• If you encounter any issues during the import process, you can contact dotCanada.com's support team for assistance.

• Regularly backup your databases to avoid data loss.

• For large databases, consider using alternative methods like mysqldump or phpMyAdmin for importing to ensure a smooth process.

By following these steps, you can easily import an existing MySQL database into your dotCanada.com hosting account through cPanel's user-friendly interface.

Updated on: 19/04/2024