Importing a MySQLdatabase using PHPMyAdmin in cPanel

Login to cPanel



You can access cPanel in a number of ways: 

Accesing cpanel through your Web Services Manager Hosting Panel

Login to http://manage.newtekwebhosting.com

Navigate to My Services Page

Click the icon on the far right to the view the hosting details

Click Login to cPanel

 

Using your domain name. Example: domain.com/cpanel

Using your IP address: Example: 12.34.56.789/cpanel






Click phpMyAdmin



Once logged into cPanel, under the Databases section click phpMyAdmin. 






Click the database to be restored



Locate the database you want the restore completed on. This database could be empty, or contain information that you want overwritten. 






Navigate to the Import Page



This is the page where you will be completing the import request.





This completes the Process.



A common Import Error:



If you receive a Access Denied error when trying to run the import, it is because the import file is trying to create a new database, rather than importing over the existing database. To stop this from happening, you can try to a new export and make sure you UNCHECK the "Create Table if does not Exist. Alternatively, you can open the database backup file in notepad and delete the line the entire line starts with "CREATE DATABASE /*!32312 IF NOT EXISTS*/`track` /*!40100 DEFAULT CHARACTER SET latin1 */;"

Was this answer helpful?

Related Articles

Creating Cron Jobs in cPanel

To create a Cron Job: 1. Log into cPanel for your hosting plan. 2. In the Advanced section,...