How to Backup and Restore your WordPress Website or Blog



Hello dear readers! Welcome back to another edition of our tutorial on WordPress. In this tutorial post, we will study about how to Backup and Restore files and database in WordPress.

In WordPress there are two parts of backing up such as -

  • WordPress Files Backup
  • WordPress Database Backup
  • WordPress Files Restore
  • WordPress Database Restore

WordPress Files Backup

To get backup files in WordPress, you need to install FileZilla Client on your computer.

Following below are the simple steps on how to backup files in WordPress -

Step 1 - Open the FileZilla Client as shown in the screenshot below.



Step 2 - Now enter your Host, Username, Password and Port just like you have used to login to your cPanel.


After filling all the fields, click on Quickconnect button.

Step 3 - You will get all files and folders of your WordPress site on the right side as shown in the screenshot below.


Step 4 - Select all the files and folders, right click on the mouse and click on Download.



After downloading the WordPress files from the cPanel, it will be saved on your computer.

WordPress Database Backup

Following below are the simple steps to backup the database in WordPress -

Step 1 - Type in the path below http://localhost/phpmyadmin into the browser. The screen below will be displayed.


Step 2 - Click on database name which you have already created for WordPress.



Step 3 - After clicking on database in WordPress, it will then open the following page. Click on the Export tab.


Step 4 - You will get two methods to export the database i.e. Quick and Custom. Select any one of the methods and click on Go button.


After exporting the database file, it will be saved on your computer.

Restoring WordPress Files

Following are the simple steps on how to restore WordPress files using ftp -

Step 1 - Open the FileZilla Client and then login to your site using ftp as shown below.



Step 2 - Open the local directory in ftp and then upload all WordPress files to your site as shown in the screenshot below.


Step 3 - Go to your wordpress folder → wp-config.php folder. You have to copy and rename that your wp-config.php file before you edit, incase of any error from you, you can restore this file back.

Open the wp-config.php and try to locate the below code -

define ( 'DB_NAME' ,  'db_name' );

Replace the db_name with your database name which you have created.

define ( 'DB_USER' ,  'db_user' );

Replace db_user with your MySQL username.

define ( 'DB_PASSWORD' ,  'db_password' );

Replace the db_password with that of your SQL password.

Save your wp-config file after you are done editing and upload it to your WordPress site through ftp.


Restoring WordPress Database

Following are the simple steps on how to restore the WordPress database -

Step 1 - Type in the path below http://localhost/phpmyadmin into the browser. The screen below will be displayed.


You can create a new database or import your backup in the existing database.

In this tutorial guide, we are going to create a new database name, i.e., new_wordpress and then click on the Create button.

Step 2 - You can view your created database as shown in the below screenshot. Click on the database name new_wordpress.



Step 3 - Click on Import.


Step 4 - Click on the Choose File button in order to choose the backup file from your computer. After uploading the sql file, select format as SQL as shown in the below screenshot.


Click on the Go button.

Step 5 - Once you click on the Go button, you are going to get a message after the sql file is been successfully uploaded.



Alright guys! This is where we are rounding up for this tutorial. In our next tutorial, we are going to be discussing about how to Optimize a WordPress site.

Do feel free to ask your questions where necessary and i will attend to them as soon as possible. If this tutorial was helpful to you, you can use the share button to share this tutorial.

Follow us on our various social media platforms to stay updated with our latest tutorials. You can also subscribe to our newsletter in order to get our tutorials delivered directly to your emails.

Thanks for reading and bye for now.