loader image
cPanel Hosting

How to use MySQL Workbench to upload databases in cPanel

1. Depending on the type of device OS download the MySQL Workbench from here

2. Open the downloaded file and complete the installation

3. Once complete, open the software on your device

4. Open cPanel Dashboard, find >> Remote MySQL and open it

5. Visit here and input your network IP to allow the Workbench software hosted in your local environment to connect to the SQL server

6. Once it is added, click Add Host

7. Now open your Workbench software in your local system

8. On top find Database >> Connect to Database and click it

9. A popup box appears and now input your server name and username

10. Then click OK, and input the password after this

11. Once connected, this should appear

12. On the left side find the option “Data Import/Restore”

13. In this tutorial, it is taken that the SQL File is downloaded in your local system.
Select “Import From Self-Contained File” and then select your database

14. Now select the database name of the cPanel server in which you want to import the SQL file from the option “Default Target Schema”

15. Click “Start Import”

16. Once the import is completed, it shall show this on the screen

17. Once completed, cross-verify the database tables from the PHPMyAdmin option of cPanel

Leave a Reply

Your email address will not be published. Required fields are marked *

You cannot copy content of this page