How to Backup WordPress Database and Files - MakeSureHow
Edit Article

  • 1 Editor

What is meant by WordPress database backup? Looks like we're no stranger to hearing it, especially if you have a blog or website with the WordPress platform. And also, if we already have a blog / website along with hosting or working in an environment Localhost Offline WordPress. Until now the database backup still was imperative and important in the world of WordPress. But, on the other hand, there is also the purpose of the database backup we need to understand to help us in managing WordPress website. Well, if you want to know more about how to backup WordPress database and files, please read more.

If there is a term in computer system backup, then the backup database WordPress also has a goal to save the system from the main data. Often the term backup on WordPress CMS appears when we will forcing something important in the WP database. I like wondering when we will update the latest version of WordPress, WordPress database optimization, change WordPress database or anything like that. But it can also be said we're making changes to the database.

As we know that having a copy or backup of all we've done is mandatory and important, so we can easily restore all missing files or site issue in hack by pranksters. There are many free and paid plugins for WordPress database backup and file are provided, but that so the question is why should use a plugin for WordPress database backup and file manually? Actually, there are many ways to create a backup file, but this post is enough to explain a few easy steps and how to backup WordPress database and file.

Let's get started!

The first backup with PhpMyAdmin as follow:

Step One: Log in to the main control panel from your web and find PhpMyAdmin database

Step Two: Open PhpMyAdmin and select database on the left side (if not found, please read tutorials find the database name in wp-config.php)

Step Three: After selecting the database name, then click export tabs on the top menu

Step Four: Choose SQL format (default) and click Go! then wait until the process export is completed and full database


In this way is quite easy but if you're still confused, try the second way by using manually cPanel as follow:

Step One: Find and open your file backup

Step Two: You will see "Download MySQL Database Backup" on backup page

Step Three: Click database name to be downloaded

So, now we quite understand how backup WordPress database using above two ways. Now let's see how to backup WordPress database with FileZilla.

Step One: In this part, we need an FTP client. Open FileZilla and connected to your web directory

Step Two: After that will come public_html, then locate the Wordpress directory and select all the files WordPress then right-click to download, or can also drag and drop.

Step Three: After download it, don’t forget to create folder in local PC and directly download the files

The benefits we get from using this way is that we get a complete copy of all the data on the website. It also does not rely on hosting data backup to create a blog or website (usually it takes 3 days). There are in some cases, hackers will act dumb and remove directories and files that exist there.

The next, this is the second way to backup file with cPanel WordPress we do it manually.

Step One: Not much different from what I mentioned, the above steps only to users host cPanel. Now open the file manager in the home directory

Step Two: After opening the file public_html next search WordPress directory and select all the files, right click, and compress to zipping archives

Step Three: Right click on files that have been compressed and downloaded to your computer

Finish! So, now we have successfully completed the process of WordPress database backup and file with an easy method

Diligent backup data is not only stored in the computer, but also all the blog content that we do during this must always be backup regularly. Backup is one precaution things happen walk-in chill on our blog. And we certainly do not want the content we've created for it suddenly disappeared somewhere and cannot be returned.

Well, all of the above is a method which is split to facilitate you to understand and found a lot ways that is considered to be the easiest to understand. If you want to find a way to backup Wordpress database with the full e-mail data and logs, then this is the tutorial you are looking for. Also, when you perform backups in cPanel and download it, and then specify the email address, then you will be able to download the full backup file.

Once you understand the meaning, purpose and way of Database Backup, to be used free of WordPress Blog Plugin for Automatic Backup. Why am I giving this way at the last session, as many of his fellow Bloggers often use Plugins without knowing what to do (a term not automatically mean good)? On the other hand, some option settings are several plugins that require skills that are qualified to provide optimal results.

Keep in mind, any method that we use to make a database or File Backup WordPress, the real key lies in restore and finish. During restore the database is not a problem, it is certain that your success rate is 100% authentic restore data. At least, you now have to start thinking importance of doing backups on the Wordpress database, if you do not want to lose data, posting missing, the script errors, important files deleted even blogs will not open at all. What is important for me, no indexation when search engines like Google, Blog you read error (syntax error) by bots crawl them. Based on my experience it potentially can decrease Page Rank and confusion to see a special title in the SERP Blog.

For that, soon do a backup. If you have any questions please leave a comment and stay connected with our website. We will be happy to help solve and find solutions to your problems in performing database backup and file in WordPress. Although it looks very easy, we still have to be careful if you want to restore data that is already in the last backup will be back as it was original.

Article Tools

Did this article help you?


an Author!

Write an Article