Below is a step by step instruction of how to correct the issue. Please follow:
- Login to cPanel
- Create a Database and a user.
- Assign user to Database
- Open (Using your favorite editor) your filename.sql (already downloaded PHPMyAdmin dump file)
- Find the following lines and remove them:
DROP DATABASE `<database_name>`;
CREATE DATABASE `<database_name>`;
USE <database_name>;
- After you have completed the above, it should look something like this:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Host: db590.perfora.net
-- Generation Time: Feb 15, 2007 at 03:44 PM
-- Server version: 4.0.27
-- PHP Version: 4.3.10-2
--
-- Database: `<database_name>`
--
-- --------------------------------------------------------
- Save the updated file.
- Go back to cPanel >> MySQL Databases >> PHPMyAdmin
- Select the database that you created above, from the drop-down menu.
- Select Import
- Then click on Browse and find the file on your computer, and click GO.
- Congrats! You’ve successfully completed a perfect restore!
If you have any further questions, please feel free to contact O2Link Support