The best way to import or export a database is via PHPMyAdmin:
Log in to the cPanel account that owns the database.
Select/Search the phpMyAdmin icon; a new window will appear showing all your databases.
Select the database name from the sidebar on the left.
If you want to Export a Database:
Click the Export tab.
Wait until your database is fully downloaded/exported via web browser.
If you want to Import a Database:
Click the Import tab.
Choose the local file that you wish to import. Common file extensions are: .sql, .sql.zip, .sql.tar.gz, .sql.gz
This may take some time depending on how heavy your backup is and your internet connection with the server.
If your SQL file is too big to import via PHPMyAdmin, please contact our support team and we would be more than happy to do it for you.