Step 1: Login to your CPANEL and then to phpMyAdmin Step 2: Click on wp_users table and then “Insert”. In the form, add information similar to the screenshot below: ID: pick any number which is not already in use. I have picked 999. user_login: this will be your username to login to the WordPress admin … Read more
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.
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.
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.