Backup And Restore WordPress Database with cPanel and PHPMyAdmin

Creating a backup is, undoubtedly, the best way to ensure the security of a WordPress site against vulnerabilities and hackers. There are several reasons that can compromise your website security and make it prone to attacks. For instance, you may be using a theme from an external source that contains malicious code. Of course, it is important that you're using a theme made available by a trusted source. For example, D5Creation is a well recognized name in the online marketplace known for offering high-quality and secure WordPrerss themes.

But, the agenda of this article is not about discussing what causes a WordPress site hacked. Rather, we would be focusing on below two techniques to back-up WordPress database:

1   Backup using cPanel X

cPanel is a well known control board that is efficiently utilized by numerous number of web host features. The reinforcement highlight can be utilized to reinforce your MySql database. Try not to create a full reinforcement process, as these are entirely for documenting purposes and can't be restored by means of panel. Search for 'Download a MySQL Database Backup' and snap the name of the database. A *. gz document that will be downloaded to your neighborhood drive.

There is no compelling reason to unfasten this record to restore it. Utilizie the same cPanel program, skim to the gz document and transfer it. Once the transfer is finished, the base of the program will demonstrate dump complete. On the off chance that you are transferring to another host, you should reproduce the database client alongside the coordinating secret key. In the event that you change the secret key, roll out all the relating improvement in the wp-config.php record.

2   Back-up WordPress DataBase By Using phpMyAdmin Process

PhpMyAdmin is defined as one of the programming styles that efficiently uses your WordPress database:

• Backup Schedule by using phpMyAdmin
• Log in into your phpMyAdmin on server
• While you are working on the main login screen, you are recommended to select 'Databases'

Next, click on the database name; else you have another option to click on the WordPress database option, if you find that you have several database options available.

The next section simply allows you to access all the tables within the WordPress database section.

Go towards the left box at the top of the Export section and here you will find that all the tables in the database that you saved and selected previously..

1. Well, if you prefer working on other programs that accepts an efficient use of your WordPress database, then it is always recommended for you to opt only those tables that matches your WordPress installation process.

2. If you only have a WordPress blog installed, then I will recommend you to click on 'Select All' option first, if you have changed the selection mode.
3. On the other hand, make sure that the SQL radio button is properly selected.

 The SQL section

Tick the following boxes:

• 'Structure'
• 'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION'
• 'Add IF NOT EXISTS'
• 'Add AUTO_INCREMENT' and
• 'Enclose all the table and field names with backquotes'

The DATA section

Working with the  DATA box section, you can access the Complete inserts and Extended Inserts  option that are mostly used for  changes to the output style.

Tick on 'Save as file' menu and leave the template name as it is.

This above diagram shown, allows you to click on 'Go' menu and you will be prompted for a file to proceed to download.
Save that file to your desktop for future use. Depending on your database size and speed, it may take a few moments.
Now here you have completed your WordPress database backup process.
You can download your WordPress backup file for future purpose, if you want it.

Restoring WordPress database by using cPanel and phpMyAdmin method

A. Using cPanel

If your hosting provider is working with the cPanel hosting control panel, then you should follow these simple steps to develop your WordPress username as well as database. Below here is a more simplified guide for using cPanel to design your database:

• Log in to your cPanel.
• Click MySQL Database Wizard icon under the Databases section.
• Create a Database, enter the database name and click on Next Step.
• In “Create Database Users”, enter the database user name and the password.
• Opt for “Add User to Database” and click on 'All Privileges” checkbox and then click on click “Next Step” menu.
• Hit on “Complete task” menu and keep a  track on database name and user. Write down all the values of hostname, username, databasename and the password that you chose.

Restoring wordPress database by using  cPanel (LPCP)

• Log in to your account.
• Go to the Control Panel section.
• Click on the left panel button, labelled as 'Go to LPCP'.
• Go to MySQL Manager section.
• Attach user name and database name
• Note the IP address of your database on the right hand side is different from the default IP number of the host indicated in the above step.
• When modifying the WP-CONFIG.PHP file, use the DB IP number, not 'LOCALHOST'.
• When modifying the WP-CONFIG.PHP document, it is quite essential that you have mentioned the full name of the database name as well as user name, such as 'accountname_nameyoucreated'.

B. Using phpMyAdmin

In the event that your web server has phpMyAdmin introduced, you might take after these directions to create your WordPress username and database. On the off chance that you are dealing with your own PC, then on most of the Linux operating systems conveyances you with an introduction to PhpMyAdmin naturally. In the event, where a database is identified with the WordPress, does not as of now exist in the Database dropdown list on the left, then it is always good to create one:

Pick up a name for your WordPress database: "Wordpress" or "site" are great, yet most facilitating administration processes that will require a name starting with your username and an underscore. In this way, regardless of the possibility that you take a shot at your own PC, we exhort that you check your facilitating administration necessities so that you can tell them all equally and have the capacity to exchange your database without alteration.

Enter the created database name in the Create database field and pick up the best assemblage for your dialect and encoding. Much of the time,  it's an ideal to pick up in the "utf8_" arrangement process and, on the off chance that you don't discover your dialect, to pick "utf8mb4_general_ci"

After naming the database and choosing the collation, click on the Create button.

• Click on phpMyAdmin icon in the upper left to return to the main page
• Click on Users tab. If a user working on WordPress does not show up in the user list, then it is recommended to create one:

1. Click on Add user buton.
2. Opt for a username for your WordPress account and enter it in User name field.
3. Opt for a secure password and enter your password in the Password field.
4. Write down the username and the password you have chosen for login details
5. Leave all options in Global privilege section as a default.
6. Click Go.
7. Get back to Users screen and click on Edit privileges icon that you've created for WordPress account. Select the database  that you have created for WordPress under the Add privileges to the following database dropdown in the Database-specific privileges section. Click Check All option to select all privileges, and then click Go.
8. Make a note of the host name that is listed after Server: at the top of the page.