Importing MySQL into cPanel (& Common Mistakes)
|
To import a database into cPanel the database needs to exist. If it doesn't cPanel may give an error, or say its been restored when it actually hasn't (if using the Backups page to restore). Note: SQL dumps over 50MB will need to be restored by us. Please upload your SQL dump via FTP and submit a ticket letting us know where the file is and that you'd like us to restore it for you. You should create the database within cPanel and confirm the name of the database we should restore it to. If your database / cPanel user name is the same as when the SQL dump was made: You should login to cPanel go to 'MySQL Databases' and create the database (and add a user to the database) and then go to 'Backups' on cPanel where you can restore your SQL dump. Note: Your cPanel username should be the same as well, because your database name contains your username i.e. cpaneluser_databasename. If your database name / cPanel user name isn't the same as when the SQL dump was made: You should login to cPanel go to 'MySQL Databases' and create the database (and add a user to the database). You then need to go back to the cPanel main page and then select PhpMyAdmin. Once in PhpMyAdmin, select the correct database name from the left, and then click the Import icon and select the file containing your SQL dump. The dump will now be restored to which ever database you selected. |
Also Read
