How to Backup the WordPress Database

how to backup WordPress database

Every website is created with a lot of efforts it would be a shame if you will have to lose the information you have in here.

Most of the websites that have external elements get backed up by the cloud and for backing up the data on your site, the onus is on you. The data backup process can be done using either plugins or manually. If you want to keep a backup of your database follow the steps and learn easily how to backup WordPress database of your entire WordPress website

The websites collect a lot of external data and along with that, there are various different threats to the safety of the website.

To ensure that your website is up and running at all times it is always advised by the experts to keep your site backed-up.

The whole website consists of so much information and it cannot be recreated so having a backup for all the information is needed.

How to Backup WordPress Database Manually?

WordPress has made efforts to ensure that the users get all kind of support. The manual back up of data provision shows how dedicated the platform is in offering suitable features.

When you know the simple steps then you can create a manual backup whenever required. The database backup is a safety net that makes you realize you are secure with all the relevant information.

Before we jump to the steps on how to manually create a database let’ see the situations when the data should be manually backed up.

The users should always create a manual back up for the data to protect it from a situation in case something goes wrong. The use of the WordPress backup system will ensure that you have all resources to restore the site in case something goes wrong.

There are many situations when a user loses access to their admin area if an attempt to hack the site is made or if the plugin installed shows some error.

It is advised in these situations that a WordPress backup is created. Now if you do not have access to your own admin area then creating a backup becomes a tricky business.

The plugin in these situations cannot be used for backup and the manual backup knowledge is required. The process is not very different and the manual backup is made in the same way the plugin creates a backup.

If the steps are followed in the right manner then the files are backup with perfection saving a lot of time.

Creating a Backup Manually Using phpMyAdmin

Use the phpMyAdmin and create an effective backup. This is an open source software that is readily available enable the website owners to manage the MySQL database.

It is made possible by using the web-based interface. Most of the WordPress hosting providers have it pre-installed.

To start with you will have to log in to the WordPress hosting control panel. You will then have to click on the phpMyAdmin which is stacked under the database section.

Your phpMyAdmin window will be launched in seconds. You should have your WordPress database selected inside this Admin Panel. You will have to manually check this, if it is not selected then you are advised to select it manually.

You will now be able to see the whole list of the WordPress database tables when you have your WordPress database selected. You will see many small action buttons on the top click on ‘Export link’ from the top menu bar.

You will be asked to choose the export method. It is best to choose ‘custom’ as your preferred method of export as it provides more options to you.

Once you select that all the options will unfold right in front of you. There will be a table display with the options of select and deselect, this list has various plugin options included in them. If you do not want to select any of the tables mentioned on the list manually go ahead and deselect them.

Next, you will see the Output section when you scroll down the page. You will be able to see the output of the export as text as this is the default format.

If you wish to change it then you can make changes and select save the output as a file option. If you want your files to be compressed you will have to select zipped or gzipped option.

Go to the end of the page and click on ‘go’ button. Your entire database will be exported to you in a zip or gzip format.

In case you are using cPanel then you will use your hosting control panel and manually scroll through the files section. You will see a button with backup on it.

Most of the popular webs hosting sites have the same option. You will be directed to a backup page, here you will have to select your database name from the long list of options.

Download the database backup file from here. Your WordPress files can also be downloaded from here. If you are manually backing up your database make sure that you do not make it your only system.

This knowledge comes in handy when your plugins fail or in special cases but you should not solely rely on them as a timely backup by using plugins cannot be ignored. This should not be a preferred backup alternative to the proper backup solution.

It is best to have a proper and timely backup plugin installed for your site’s protecting and this can be used in some special situation when the plugins fail.

Think of a situation when the hosting site has suspended your account then you will not be able to make a manual backup using the cPanel and will be in a tough situation.

Sometimes WordPress is unable to connect to the MySQL database, all WordPress pages show error establishing a database connection which is a common problem.

The best way is to have a proper plugin that backs up your data to the cloud on a regular basis. The storage space is chosen by you and whenever you feel the need then you can opt for an additional manual back up of data just to be sure.

Both the process can be used for different situations and time keeping the website absolutely safe.

Leave a Reply

Your email address will not be published.