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 -
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.
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.
RECOMMENDED: WordPress Spam Protection
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 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.
RECOMMENDED POST: How to Customize WordPress Theme
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 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.
RECOMMENDED: How to Enable Comments in your WordPress Blog
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 1 - Open the FileZilla Client and then login to your site using ftp as shown below.
RECOMMENDED: The Ultimate Guide to Adding Tags in WordPress
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 -
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.
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.
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.
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.
RECOMMENDED POST: How to Edit Categories in 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.
Step 5 - Once you click on the Go button, you are going to get a message after the sql file is been successfully uploaded.
RECOMMENDED POST: The Ultimate Guide to WordPress Plugin Settings
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.
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.