1. Files restoration
2. Databases restoration
3. Updating configuation files
4. Emails restoration
This tutorial will cover the information on how to manually restore full cpanel backup (sites, databases and emails). It will help you to protect your data and will allow you to merge/separate few cPanel accounts.
Unfortunately full cPanel backups can not be restored automatically from cPanel interface, however you can upload the backup to your Home directory and submit a ticket to Hosting—Support department to have it restored by our technical team.
*note: this will overwrite all the current files.
There is no automated way to separate/merge few cPanel accounts or to restore the partial backups. So you might need to restore them manually and below you will find an easy step by step example with the general tips to do so.
Legend:
domain.com – the primary domain associated with your cPanel account
addon.com –the domain added as addon into the same cPanel account
domain.com has a Prestashop (popular e-commerce engine) installed on it and WordPress (blog engine) on addon.com
Let’s take a look at the situation where you have a full cpanel backup on PC.
Upload the backup-4.4.2014_domain.tar.gz to your home folder via FTP , select the file, right click on it and choose ‘Extract’ or click on corresponding button on the top bar.
On the next pop-up window you will be able to specify the path to restore the archive to, but let’s leave it empty and just click on Extract files. You will see the Extraction results table with the list of the restored files, just close it.
Now click on the Reload button on the top and you will see the newly created backup folder “backup-4.4.2014_20-24-21_domain”, lets open it.
There will be many different folders. Find the homedir, open it, there you will find your home folder.
Next, open public_html folder
It is the document root (folder with files) for the domain.com so it contains all Prestashop files. Also there is a folder addon.com , which is the document root for addon.com domain , with WordPress files.
So we can just copy everything to our public_html folder (which is currently empty).
Click on the Select all, right click and choose Copy
On the pop-up window enter /public_html and click on Copy files button
Now you can check the public_html folder, all the files should be already there.
Now let’s get back to the /backup-4.4.2014_20-24-41_domain folder as we need to restore the databases as well.
Find the folder mysql and open it
You will see some .sql files. These are backups of your mysql databases. They will be named respectively to your domain name. Hereinafter we will use domain_pres288.sql (Prestashop database) and domain_wp865.sql (WordPress database) as examples. Let’s right click on them (one per time) and download to our PC.
Now we need to restore them. There are 2 ways to do this:
- from Cpanel > Backups menu
Choose the previously downloaded .sql file on your PC and click Upload.
Then you will need to create database user and add the user to the database in Cpanel> Mysql databases menu. (you can use the same database user and password or create new)
Create database:
Create database user with some password (save the password , we will need it later)
And add the user to the database, on the pop-up windows check the option All Privileges and click on save changes.
if everything is correct you will be able to see your newly create database with assigned user.
If you need more detailed information, please refer to thisguide.
- from Cpanel>Phpmyadmin menu
At first you need to create the database, database user and password in cPanel > MySQL Databases menu.
We have already created the database , user , password and added the user to the database but it is still empty.
Now open Cpanel> phpMyadmin menu
Click on the “+” on the left of the cPanel username and click on the database name
Click on import on the right top bar and browse to the corresponding .sql file on your PC (here domain_pres288.sql)
and browse to the corresponding .sql file on your PC (here domain_pres288.sql)
Scroll down and click ‘Go’ to start the import.
You will see a green notification that your database was successfully imported.
If you need more detailed information, please refer to this guide.
3. Database configuration files
We are almost done. The last step is to update the configuration files of Wordrpess and Prestashop with the correct database details.
Open the restored public_html folder and browse to the addon.com folder, find the wordpress wp-config.php file , which contains database details , select it, right click and choose edit.
Find the following 4 lines and make sure they have valid data (database name, user and password), change the characters inside quotes if needed and save the file.
That’s all for WordPress, now it’s needed to perform the similar changes with Prestashop.
Browse back to the public_html folder and find the config folder
Open it , select the settings.inc.php (Prestashop config file with database details) file, right click on it and choose edit.
Find the following 4 lines and make sure that they have valid data. Similar to what we did to wp-config.php file.
That’s it. If your domain is already pointed to the hosting server you will be able to open domain.com or addon.com in browser and see WordPress/Prestashop up and running.
In case you had some important emails, you are able to restore them from full cpanel backup as well.
For example , we had an email account contact@domain.com with some emails and occasionally deleted it. But we have a full Cpanel backup or Home folder backup .
First, it is necessary to recreate the same mailbox from Cpanel> Email accounts menu. You may refer to this article http://www.namecheap.com/support/knowledgebase/article.aspx/110/
Now, browse to the backup folder >> homedir folderand open the mail folder.
See the .contact@domain_com folder ? It contains all our folders with emails.
Open it, click the select all button and click Copy
Then on the pop-up windows put the following path /mail/.contact@domain_com and click Copy files .
That’s all, check your emails via webmail or email client.
Config files and folders may vary from one hosting provider/script template to another but the main points remain the same. If you can’t find the corresponding files or not sure what details to put – feel free to contact us via live chat or ticket using our helpdesk .