• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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