Due to a limitation in cPanel it is not possible to restore a database that is larger than 2Mb in size. You may receive an error message or just a blank screen:
Fatal error: Maximum execution time of 300 seconds exceeded
If you wish to restore a database larger than 2Mb, please create a ticket to the technical support department and we will be happy to restore it for you. For more advanced users familiar with SSH please follow these instructions:
Upload the database backup to the root directory of your account. The database backup is usually in .sql format. Ensure you upload the file to the absolute top level of your FTP account, your FTP program should display / and you you will see folders such as "tmp", "usr" and "var".
Now connect to your account using SSH and enter the following command:
cpaneluser - Replace with your cPanel username, this prefixes all MySQL users and database names
mysqluser - The is the MySQL User you wish to restore the database to
databasename - This is the name of database itself
nameofbackup.sql - Replace with the actual name of your backup file
Press enter. There will be a delay while the database is restored, this will vary depending on the size of the backup.
When the process is complete the command line will appear.
mysql -u cpaneluser_mysqluser -p cpaneluser_databasename < nameofbackup.sql
Replacing the values as follows:
The database has now been restored.
