wordpress db backup and restore

How to do WordPress DB Backup and Restore without plugin ( in 1 easy step)

In this article, I am going to show you how to do WordPress DB backup and Restore without any plugin. The steps are very easy. Hold tight and follow every step that I am performing here.

wordpress db backup and restore

The below steps show how to perform WordPress DB backup and Restore with and without any plugin. These steps won’t take more than 15 minutes to perform but do not skip any steps as it may break your website permanently. So, do everything as given in the steps below to perform WordPress DB backup and restore it.

Total Time: 15 minutes

Lets’ learn how to perform WordPress db backup and restore. Go to your hosting account’s C Panel

Depending on the hosting provider, this step varies. Here I am showing you in two hosting providers i.e. Go Daddy and Siteground. In GoDaddy, you need to go to Products-> Web Hosting -> Manage-> cPanel Admin

In Siteground, You need to go to Website-> SiteTools.

Go to PhpMyAdmin

phpMyAdmin GoDaddy

In GoDaddy, you need to go phpMyAdmin.

In SiteGround, you need to go to Site-> MySQL-> phpMyAdmin.

If you are using other hosting services, these two steps might be different but every hosting provider provides this option in their hosting panel option.

Select the database of your WordPress website

wp-config db user name and password

These steps are the same for all hosting providers as it is MySQL which is same for everyone.

Note: If you are not sure which one is your database. Go to File Manager. Open the wp-config.php file. You can see your database name there. It will look like the picture shown above.

Select all the table and click on export

wordpress db backup and restore

Click on the database name on the left panel and it will show all the table as shown in the above picture. Click on ‘Check All’ checkbox and all the table will be selected. Click on ‘Export’ button on the header menu of the table.

Select the format as ‘SQL’ and you are done.

DB Format

Select the DB format as ‘SQL’ as it will be easier for you to restore the DB. Click on ‘Go’ button.

Let’s start the restore process.

phpMyAdmin GoDaddy

To restore DB, the process is almost same. Now to restore the backup, you need to have a DB if you already do not have one. The process is very easy. Go to Hosting Provider control panel and go to MySQL Databases.

Create a Database.

Create DB

Click on Create Database. A database will be created. You can change the name for some hosting provider. And, some hosting provider won’t allow you to change the DB name.

Create a DB User.

Create User

Next step is to create a DB user. You can create a DB user from that tab only. The picture above shows how to create a DB user in cPanel.

Now add the DB user to the Database

Add user to DB

Now add the user to database so that the user can access the database.

Once DB is created, Click on phpMyAdmin

phpMyAdmin GoDaddy

once the DB is created, click on phpMyAdmin of the database.

Click on Import button.

wordpress db backup and restore

Select the DB name in the left panel and click on ‘Import’ button. Once you click on ‘Import’ button, this screen will show up. Select the ‘Choose File’ option and select the DB backup (.sql, .sql.zip, .sql.tz files etc.) and click on ‘Go’ button.

Voila. Now you learn how to do WordPress db backup and restore. You can use plugins as well to perform WordPress db backup and restore.

You can learn how to do WordPress DB backup and restore using plugin by clicking this.

Leave a Comment

Your email address will not be published. Required fields are marked *