MySQL issue when Moving a downloaded DataBase from Plesk 7.5 to Cpanel

[Forgotten_1]

I am switching my hosting from a Plesk 7.5 (windows) control panel to Cpanel (red hat). I download the Database and when I try to import it to my Cpanel account I recieve the following error on every attempt and database I try to import. Any suggestions on how this can be done correctly?


Error:

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: May 21, 2005 at 02:52 AM
-- Server version: 4.1.7
-- PHP Version: 4.3.10
--
-- Database: `tchqe107`
--
-- --------------------------------------------------------
--
-- Table structure for table `e107_banlist`
--
CREATE TABLE `e107_banlist` (
`banlist_ip` varchar( 100 ) NOT NULL default '',
`banlist_admin` smallint( 5 ) unsigned NOT NULL default '0',
`banlist_reason` tinytext NOT NULL ,
PRIMARY KEY ( `banlist_ip` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1' at line 24



All information I have reviewed hasn't been able to provide me with a work around. Any suggestions people? I could surely use your assistance on this.

Thanks,
Forgotten_1

 

[WilliamE]

Are you running the same version of MySQL on both servers? Sounds like you might be running different versions on both servers and thus the syntax and supported options are difrerent.

 

[Forgotten_1]

With Cpanel we have 4.0.24

With Plesk we have 4.1.7

So this issue is that the versions we have from Plesk are higher then that of the version on Cpanel. Will a simple upgrade of MySQL to the version (or above) used by our plesk databases work without error?

I am guessing that the main issue here is that the newer version of MySQL creates option and such that the earlier version does not have. Right?