What is the fastest way to backup and restore website files and its mysql database?

MooseLucifer · Sep 3, 2020

I am using cpanel server, I am looking for a way to backup and restore websites including its files and databases only. Website are running on wordpress platform, I don't expect to use a plugin, i like using ways to work on hosting directly to backup files and mysql database in a fastest and easiest way. Can you guys suggest me some?

Fusion Arc Hosting · Sep 3, 2020

Hi MooseLucifer,

Thank you so much for your question!

I have done migrations myself and would be happy to explain how this can be done.

WARNING: Make sure you keep a full backup on your local computer while doing migrations. Also keep the remote server and or account active until you know all files have been transferred successfully. This is to make sure the data is not lost.
* Best to be done while having root access to a server.

How to backup all content within a cPanel account:
This includes backup of (All files, pictures, databases, and more)

Step 1: Log into your cPanel account in question. Locate "Backup" click on it.

Step 2: Click on the blue button "Download a Full Account Backup"

Step 3: Generate a backup.
NOTICE: Depending on the size of your website and its contents this may take a while. However you will get a notification via email of when it is complete.

Step 4: When the backup is complete within the same "Backups" page you will now see a new backup under "Backups Available for download" as shown above.
Step 5: Download that and you have successfully made a full backup of your cPanel and its contents.

=================================================================================================

How to restore all content within a cPanel account using a full cPanel backup via Command Line:

Step 1: If you do not have root access provide your web hosting provider the backup file as they need to restore it for you. However if you do have full root access to your server example (VPS or Dedicated Server) log into your server as root.
Step 2: Upload the file to your server via FTP under /home.
Step 3: Within the command line under /home you can take a full account backup using the script: /scripts/restorepkg filename . The filename will be the name from your backup usually the cPanel log in username.

Step 4: Run this command an you will get an output from the server within the command line giving you an update on the status of the restoration.

Congratulations the restore is complete go back to cpanel on the new server and check the cPanel for any missing files and data. Let us know of any questions we are happy to help.

Thanks!

Mario Cano

Linux Systems Administrator

Fusion Arc Hosting · Sep 3, 2020

Hello again,

I also wanted to add a few other ways of making backups and restoring. Please see below:

How to Download Backup of Home Directory, MySQL or E-mail Only?
1. Log into your cPanel account.
2. In the "Files" section, click on "Backup Wizard" Icon.

3. Under "Backup or Restore" text, click on the "Backup" button.

4. In the 2nd step "Full or Partial Backup" option, under "Select Partial Backup", you need to click on "Home Directory" to download home directory only or should you wish to download only "MySQL Databases", click on "MySQL Database".

5. Now click on the "Download" link/button.

==================================================================

How to Restore cPanel Backup non root?

1. Log into your cPanel account.
2. In the "Files" section, click on "Backup Wizard" Icon.

3. Under "Backup/Restore" text, click on the "Restore" button.

4. Under "Select Restore Type", choose the appropriate option.

5. Click on "Browse", select your backup file from your PC, and click on the "Upload" button.

===============================================================

How to generate a cPanel backup and sent to FTP Server?

1. Log into your cPanel account.
2. In the "Files" section, click on "Backup" Icon.

3. Under "Full Backup", Click on "Download a Full Website Backup" button.

4. From Dropdown menu, Select Backup destination to "Remote FTP Server", In Email field enter your email address.

Remote Server: FTP IP address or FTP domain name like ftp.example.com,
Remote User: Your FTP Username
Remote Password: Your FTP Password
Port: 21 or other FTP Port
Remote Dir: Remote Directory like /home/username/backupfolder/

5. Once you fill in the Remote FTP details, click on the "Generate Backup" button.

============================================================

Thanks!

Mario Cano

Linux Systems Administrator

Mjlivera · Sep 4, 2020

@Fusion Arc Hosting I also like this feature in cpanel but how long does it take time to backup successfully a website or emails? does it allow to run under background? and notice when its done?

Fusion Arc Hosting · Sep 4, 2020

Mjlivera said:
@Fusion Arc Hosting I also like this feature in cpanel but how long does it take time to backup successfully a website or emails? does it allow to run under background? and notice when its done?

Hello Mjlivera,

Thank you for your question! Happy to answer that for you.

I also like this feature in cpanel but how long does it take time to backup successfully a website or emails? does it allow to run under background? and notice when its done?

Excellent question. So the time it take for cPanel itself to create a backup depends largely on your cPanel total disk usage and even more on the servers I/O read and write performance. To put it in perspective when I created a backup today for a 20+GB disk usage cPanel it took the server roughly 30 minutes to 1 hour. However we are using SSD based servers which does drastically improve I/O speed.

Commonly for shared web hosting during our migrations I see an average of 5-28 minutes. Again depends on the disk size of the transfer and the remote server hardware and network uplink speeds.

As for running in the background. Yes the backup solution in cPanel will continue to run in the background until completed. In the full backup option you can even specify an email for the system to alert you of when the backup has fully completed.

I hope I was able to adequatly answer your questions. If not please let me know of any further questions at all I am happy to answer them

.

Thanks!

Mario Cano

Linux Systems Administrator

fiz · Sep 21, 2020

MooseLucifer said:
I am using cpanel server, I am looking for a way to backup and restore websites including its files and databases only. Website are running on wordpress platform, I don't expect to use a plugin, i like using ways to work on hosting directly to backup files and mysql database in a fastest and easiest way. Can you guys suggest me some?

There are too many ways to backup and restore only files and database of a Wordpress site:
1. Softaculous: Backup/Restore Feature (Only if you have it)
2. cPanel Backup: (Home directory and Database separately) You can take a Full backup but will contain everything in that cPanel account
3. WHM: Backup/Restore New bulds of WHM now provides the option to choose what to restore and backup.
4. SSH: tar the desired folder and take a MySQL dump
5. SSH: /scripts/pkgacct <cpanel-user>

Do not hesitate to reach me out in case you have any questions.

etechsupport · Oct 21, 2020

Restore home directory backup in cPanel

Login to your cPanel.
Under the files section, click on Backup.
Click on Choose File.
The name of your backup should now be displayed, so click on Upload.
You should then see the progress of your files being restored.

What is the fastest way to backup and restore website files and its mysql database?

Well-known member

Well-known member

Attachments

Well-known member

Member

Well-known member

Well-known member

Well-known member

Sponsors

Tag Cloud