How to Upload Database Backup on Cpanel Godaddy

GoDaddy's site hosting service has automated backups as a feature. Before depending on GoDaddy backups as your primary backup solution, you need to know if they are reliable.

In this commodity, nosotros talk about what good backups are, and if GoDaddy backups are good. Nosotros put GoDaddy backup and restore through its paces to see what worked and what did non.

TL;DR: Backups provided by spider web hosts are only non reliable, and oftentimes not like shooting fish in a barrel to use. Every bit a best exercise, you should always have a secondary backup plan if yous desire to protect your website. Go reliable backups for your WordPress site that are securely stored offsite and tin can exist restored speedily and easily.

Testing GoDaddy backup and restore

While evaluating GoDaddy backups, nosotros wanted to find out how reliable and piece of cake to create and restore they are. Other criteria on our heed were offsite storage for the backups, every bit host backups may not piece of work if host-level issues arise.

We tested 3 sites for the purposes of figuring this out: a small site (6.4 MB), a large site (10 GB), and a site with a large database (174 MB).

Ways to backup your GoDaddy WordPress site

Firstly, we wanted to explore all the means you lot can take backups while using GoDaddy spider web hosting. We constitute quite a few ways, including web host premium automated backups, using backup plugins, and transmission backups via cPanel.

Automatic backups

Godaddy offers premium backups for WordPress sites that include automated daily, weekly, and monthly backups. Moreover, these backups are just stored for xxx days, which seems to exist a very short fourth dimension.

Older backups may be required, for example, if an online tool stops working or recovering a post that was deleted weeks ago.

cPanel backups

You tin can manually fill-in and restore your GoDaddy site through cPanel. These are on-demand backups, and thus cannot be relied upon except in special cases. An automated daily backup is non existence created, so y'all may not have the right backup to restore when you demand to.

Moreover, this required us to separately support our files and database, in order to completely support our website. Information technology was a long and daunting job. Any human fault during the procedure could have landed united states in trouble.

Fill-in plugins

Fill-in plugins normally piece of work regardless of which web hosting provider yous utilise. It is like shooting fish in a barrel enough to add together plugins and use them for backups. Plugins are manifestly contained of GoDaddy though. We included them in this article because, after all our testing,  we plant plugins to exist the best backup solution.

If you are looking for backup plugins, our recommendation is BlogVault, which automatically takes backups of your site and stores them offsite. BlogVault's backup restore feature is a one-click process that is actually fast and reliable. Unlike our experience with web host backup and restore.

How to Fill-in a Consummate WordPress site using GoDaddy cPanel

The nearly of import matter to protect your site is to take a consummate backup. The backup should include both files and the database, as both are critical components of your site. GoDaddy cPanel didn't help united states do this easily. Nosotros had to use two different tools.

We used the File Manager to create a backup of the files, and phpMyAdmin to export the database.

Fill-in files using GoDaddy cPanel File Director

The GoDaddy dashboard is not complex to use. Nearly of the tools you need are on the dashboard, not hidden away in other places. We used  File Director to access the public_html binder, the principal WordPress directory.

Full fill-in of files

In club to create a total backup, we beginning made a copy of all the files and then compressed them. We downloaded the compressed file and named it meaningfully so that we would be able to remember what it contains if we came back to it.

Nosotros too included a number on the backup name for reference every bit a best practice. Equally we are creating files and database backups separately, it is necessary to know which file backup is relative to which database backup. Nosotros used the same number to name the respective database fill-in.

Backup speed and how it affected the site: As nosotros had compressed the files before downloading, we saved a lot of fourth dimension and our site speed was not visibly affected. The download didn't slow it down, which was great.

Backup database using phpMyAdmin

The database contains pages, posts, comments, and content related to orders and customers. And so information technology is critical that we back information technology upward. You can download a backup of your database from phpMyAdmin.

Complete Database Backup

Click on the database proper noun on the left sidebar and click on Export from the top menu. At this point, y'all can choose Quick export and .sql format to download the fill-in file.

Don't forget to name it meaningfully every bit discussed before. We also recommend calculation information about what it contains, so it becomes easier to place afterwards on.

We downloaded the database backup for our site and used the reference number we had included in the file backup proper noun.

This will allow u.s.a. to associate the correct files and databases if we have multiple backups stored on our computers.

If this wasn't a test, we would definitely have more backups stored locally. 30 days' worth of backups is nowhere almost enough.

Partial Database Fill-in

WooCommerce users may need to have a partial fill-in, i.e. fill-in of particular tables, for example, related to customer info or order data. It is pretty straightforward to do so.

Only select the tabular array you desire to download past clicking on the database proper noun. And then consign it using the Quick selection.

Or instead of selecting the tabular array on the left sidebar, you lot tin can click on the database proper noun so export and choose the Custom pick. From here, select the tables yous desire to backup and export your files.

Our take on GoDaddy cPanel backups

Our experience of taking manual Godaddy backups was okay because we have an idea of the correct processes.

Even so, for someone coming to these tools for the first time and specially for someone who is not well-versed with the WordPress file and database construction, this can be an intimidating task. Due to this reason, it may also exist time-consuming.

However, cPanel backups are a good selection for urgent on-demand backups when y'all don't take a tool for automatic backups. Let us mention that this should never be the instance.

We observed a few things while creating manual backups. You need to name the backups properly in order for them to have any meaning for you lot after on.

You may have a fill-in file, but you do not know what it contains. It may be difficult to choose the correct version, especially if you have multiple manual backups stored at the same location.

Moreover, your file fill-in and database backup should have some kind of connecting reference that helps you effigy out which file backup corresponds to which database backup.

The bottom line is transmission backups are not sustainable, as information technology'due south similar having insurance for a single twenty-four hours. You need to have daily backups to go on your site secure.

How to Restore your WordPress Manually via GoDaddy

No matter how conscientious you lot are, things go wrong. That'southward why it is important to have a proper restoration plan in place equally well. If you have used a plugin to backup your files, your plugin may also let you lot to restore your site too. However, most plugins do not allow you to upload a backup that you created manually through cPanel.

We will discuss how to restore your site manually and the limitations of doing so. We will also elaborate on our experience in the restoration process using the same GoDaddy cPanel tools which we used for creating backups in this section.

Restoring a site is pretty straightforward. Yous have to delete the existing files and import the backups—the database to phpMyAdmin and the files to the File Manager.

All the same, deletion of data means two things. Firstly, your site volition go downwardly during the restoration procedure. Secondly, in instance the restoration fails and y'all do not accept some other skillful backup, you may cease upwards losing your website.

Restoring the database from fill-in

In phpMyAdmin, locate your website'southward database and click on information technology. On the right side, cull all the tables and from the drop-down select Drib. You may have to drop tables multiple times, depending on the size of the database. Once there are no tables left, click on import and choose the backup file you wish to restore.

Restoring the files from backup

In File Director, locate the public_html folder for your website. Select the files in this folder and delete them. Now upload the .zip backup file from your computer to the public_html folder. Excerpt it to restore your files.

Our assessment of GoDaddy manual restoration

As we mentioned earlier, nosotros tested three sites, small, large, and one with a large database. While we successfully managed to restore the small site we had problems with the other 2.

Small site: Our small site was less than 8 MB. We could hands restore both the files and the database through the cPanel. Every bit the site size was small-scale, the downtime was negligible. This method worked well for the small site.

Large site: Using the same method equally for the small site, we selected our current files and database for the big site and started to upload our backups. However, due to size restrictions, nosotros were non able to upload the files successfully.

Our file size was more than 500 MB, which is the limit given in File Manager. The only way to restore it now was to use an FTP client such as FileZilla. This was a great bargain of extra work for something that should have been straightforward to do.

Site with a big database: This manual restoration landed united states of america in trouble. Nosotros deleted the database of our site and started to upload the backup. Our database was 174 MB and the maximum limit of file upload via phpMyAdmin is merely 50 MB.

That means sites with high content frequency and others such as WooCommerce sites should not rely on this method for restoration. We lost the site with this method.

Nosotros can iterate the importance of automatic daily backups here. They deed every bit insurance for your site if anything goes wrong. You can only rollback to the version you want without any issues

Partial restoration via GoDaddy cPanel

There may be times when you lot demand to restore a single file or tabular array. A plugin may suspension, a post may get deleted, while other content has been added, or you may need to restore a page that was deleted weeks ago without losing the progress on your site. In all these cases, a fractional restore tin salve the day.

Partial File Restoration

The .zip folder yous downloaded on your computer during the transmission backup contains all your files. In social club to upload a unmarried file—for example, a theme—you need to excerpt this .zip folder and choose the right file. This tin can be tricky, especially if you don't know which file contains the data that you need.

To restore the file, you need to enter FIle Manager, access the file location from your public_html folder, and delete it. So import the fill-in file that you need to restore.

Partial Database Restoration

Restoring one or a few tables from your database backup tin can be catchy. The database is downloaded as a .sql file, and unless you are a programming skillful, it is difficult to partially restore from this file.

Then, for partial database restoration, you must accept a partial backup to start with. The trouble with this method is that someone would have to accept the magical futurity sight to know which table they want to restore when taking the partial backup in the first identify.

Troubleshooting GoDaddy backup errors

A lot of things can become incorrect while creating or restoring a backup manually. As we saw that the process is non foolproof itself, additional issues such as failed connections, incomplete files, etc. can arise at any time.

Connexion issues: Internet connections can be unreliable and this can lead to incomplete downloads or uploads. It is advisable to utilise a strong connectedness while creating backups and restoring your site.

Incomplete backup files: While you lot don't see anything wrong with the backup files downloaded on your laptop, they may not contain complete data. You may want to check the file size earlier and afterwards downloading.

Failed uploads: An import can fail due to diverse issues, such as connection mistake, incomplete file, cPanel limitations etc. You will have to restart the process, which means the downtime for your site will but increase. However, this is the simply solution you take if you exercise not have a restoration tool.

Deletion of files and database: To restore the site, you lot will need to delete the existing files and database. The site will go down once you delete the files. Moreover, in instance of whatsoever issue with the restoration, the downtime volition increment. If you do non have another good backup, you may even cease up losing your website. You lot should use a fill-in plugin that offers easy restoration.

Godaddy Fill-in and Restore Conclusion

As we observed during our evaluation, GoDaddy backups are non reliable. There are a number of problems that can lead to a compromised website.

The whole betoken of having backups is to minimize the bear upon of issues with your site. If the backups don't see that criteria successfully, it doesn't make any sense to support your website using GoDaddy.

Moreover, manual backups are either saved on your computer or uploaded to a remote bulldoze. This will cause both a storage and security issue. Reliable backups are usually stored in an encrypted form in a way that they tin can exist restored with minimal effort.

BlogVault is one such plugin that offers reliable backups and quick restores without limitation on site size. We recommend you try it out.

fitzgeraldknewhervel1945.blogspot.com

Source: https://blogvault.net/godaddy-backup-restore-review-guide/

Share this post