Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us
Knowledgebase / cPanel / Why do I get a MySQL Import error?

Why do I get a MySQL Import error?
Print
Email to friend
Views: 51
Votes: 0
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
Others in this Category
document How do I view my account resources (e.g. disk space,bandwidth)?
document How do I manage my ftp accounts?
document How do I create subdomains?
document How do I create add-on domains?
document What is .htaccess?
document Fantastico Installation Scripts
document Checking IP Address of website
document How can I view my site?
document How do I stream Real Audio and Video Files?
document How do I setup a password protected directory?
document How do I backup my entire site in cPanel?
document How do I create a Sub-Domain?
document What are all these directories I see in my account?
document What is phpMYyAdmin?
document What is the path to my public_html?
document What is the path to Perl?
document Introduction to Your Home Directory
document Contents of Your Home Directory
document Installing SSL on a primary domain (e.g. www.domain.com)
document Installing SSL on your cPanel
document IP Address / SSL Certificate
document Obtaining and using SSH
document Subdomain SSL - Installation
document Server resource limits
document Setting up Audio/Video streaming
document Why do I get this add-on domain error?
document Why do I see a highload.html page?
document How do I download my raw access logs?
document Active Server Pages (ASP)
document CHMOD Permissions
document How to add an Add-on domain to my account?
document Multiple Languages


RSS
Powered by KBPublisher (Knowledge base software)