How to import your database

Login to phpMyAdmin and select the database you want to import the data to from the list on the left sidebar. Once selected click on the Import tab on the top navigation menu.

How to create a new database on your server

The easiest way to create a new database is through the MySQL Database Wizard. Here are the steps involved. Enter the new database name and click “Next Step”. Create a new MySQL user (with a secure password). Grant “All Privileges” to this user account.

How to backup your database

Login to the cPanel of your web server and open phpMyAdmin. Select the database that contains the WordPress installation from the list on the left sidebar and once selected click on the Export tab on the top navigation menu. Another way of taking the backup is through the Backups section of your hosting.