• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Import Database Error

B

bluepearl

Guest
Dear All,

I am trying to import an existing database into plesk 8.0.0 which was created using OsCommerce and I'm having a few problems. When I try to import the file into Plesk it pops up with an error:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.domain-name.co.uk
--
-- Host: domain-name.co.uk
-- Generation Time: Nov 06, 2006 at 12:57 AM
-- Server version: 4.0.27
-- PHP Version: 4.3.10-200.schlund.1
--
-- Database: `old_dbnamehere`
--
CREATE DATABASE `old_dbnamehere`


It has a note underneath this explaining:
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.mydomain.co.uk
' at line 1

Could anyone point me in the right direction please as I can't find any solutions to make this work.

Thankyou in advance,
Stephen
 
Back
Top