0

Backup & Restore Files and Database in WordPress

Customize Plugins in WordPress

Backup & Restore Files and Database in WordPress

In this article you will how to Backup & Restore files and database in WordPress. In WordPress there are two parts of backing up such as −

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

Files Backup

To get the backup files of WordPress, you need to install FileZilla Client on your system.

Following are the simple steps used for files backup operation in WordPress −

#1 Step

Open the FileZilla Client as shown in the following screenshot.

Backup & Restore Files and Database in WordPress 1

#2 Step

Enter the Host, Username, Password and Port like you have used to log-in to your cPanel.

Backup & Restore Files and Database in WordPress 2

After filling all the fields, click on Quickconnect button.

#3 Step

You will get all files and folders of your WordPress site on the right side as seen in the following screen.

Backup & Restore Files and Database in WordPress 3

#4 Step

Select all the files and folders and right click on the mouse and click on Download.

Backup & Restore Files and Database in WordPress 4

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

Database Backup

Following are the simple steps for database backup in WordPress −

#1 Step

Type the path http://localhost/phpmyadmin in your browser. You will get the following screen.

Backup & Restore Files and Database in WordPress 5

#2 Step

Click on the database name ‘wordpress’ which you have created for WordPress.

Backup & Restore Files and Database in WordPress 6

#3 Step

After clicking on database wordpress, it will open the following page. Click on Export tab.

Backup & Restore Files and Database in WordPress 7

#4 Step

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.

Backup & Restore Files and Database in WordPress 8

After exporting the database file, it will get saved on your system.

Restoring WordPress Files

Following are the simple steps used to restore the files in WordPress using ftp −

#1 Step

Open the FileZilla Client and login to your site using ftp as shown in the following screen.

Backup & Restore Files and Database in WordPress 8

#2 Step

Open the local directory in ftp and upload all WordPress files to your website as shown in the following screen.

Backup & Restore Files and Database in WordPress 10

#3 Step

Then, go to your wordpress folder → wp-config.php file. Copy and rename wp-config.php file before editing, in case of some mistake you can restore this file back.

Open the wp-config.php file and locate the following code.

define('DB_NAME', 'db_name');

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

define('DB_USER', 'db_user');

The db_user is to be replaced with your username of MySql.

define('DB_PASSWORD', 'db_password');

Replace the db_password with your password of MySql.

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

Restoring WordPress Database

Following are the steps used to restore the database in WordPress −

#1 Step

Type the path http://localhost/phpmyadmin in the browser. The following screen will pop up.

Backup & Restore Files and Database in WordPress 11

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

Here we’ll create a new database name, i.e., new_wordpress and click on Create button.

#2 Step

You can view your created database as shown in the following screen. Click on the database name new_wordpress.

Backup & Restore Files and Database in WordPress 12

#3 Step

Click on Import.

Backup & Restore Files and Database in WordPress 13

4 #Step

Click on Choose File button to select the backup file from your system. After uploading the sql file, select format as SQL as shown in the following screen.

Backup & Restore Files and Database in WordPress 14
Click on Go button.

#5 Step

Once you click on Go, you will get a message after the sql file is uploaded successfully.

Backup & Restore Files and Database in WordPress 15

WordPress Way Blogging Tutorial

Please follow and like us:
302

Mike