With the expansion in a WordPress website, there is also an increase in the data stored on the server. With new posts, web pages, visitor comments, new information added and with any other new content, the database also keeps growing simultaneously. You will be surely provided with a backup facility with the WordPress Hosting plan however it is also crucial for you to take the necessary steps to safeguard your data so that it becomes easier to restore them in case of a disaster. Although there are a few plugins that would enable you to take the backup of your website, however it is really simple to take the manual backup. The complete process of taking the backup of your WordPress website.
An FTP client is required for taking the backup of your WordPress website. Therefore you must setup a connection with the host’s FTP server and then look out for the WordPress installation directory. You must locate a folder names ‘WordPress’. Download the complete directory to your machine.
With the WordPress Hosting UK account, you can easily manage your database through phpMyAdmin. In case you are using any other DB administration tool the procedure might be slightly different, however there wouldnt be any difference in the functionality. You will nnopw have to access the phpMyAdmin and locate your WordPress database. Once you have located it, go to the Export tab and click on it for exploring the database.
After clicking on the Export option, you will see the screen that is illustrated below. In column present on the left, you will find a list of all the tables present in the WordPress Database. Select SQL as the format for exporting and check the option that says Save as file. Now click on Go, this step will export the database. The file that consists of all the SQL statements necessary for creating the database will also get downloaded. By default, the file name would be similar to your database name example : databasename.sql.
This step is for restoring your WordPress website. This is a very simple step. All you have to do is upload your WordPress directory on the server and restore your database with the
databasename.sql backup file that was downloaded in Step 2. Use of a secure FTP client for restoring the WordPress files back to the server is highly recommended. You must also take care to use the same location that was used when you downloaded the file. Before restoring the data a new database has to be created. This can be done by going to phpMyAdmin. You can also contact the support department for assistance doing that.
Once this is done, click on Import link.
You will then be asked to select the database file i.e. databasename.sql
The database will be restored as soon as you click on GO.