1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Import Database Error

Discussion in 'Plesk for Linux - 8.x and Older' started by bluepearl, Nov 10, 2006.

  1. bluepearl

    bluepearl Guest

    0
     
    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
     
Loading...