Knowledgebase
Knowledgebase / cPanel /
Email to friend
* Your name:
* Your email:
* Friend's email:
Comment:


Why do I get a MySQL Import error?
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


RSS
Powered by KBPublisher (Knowledge base software)