The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by Forgotten_1, May 23, 2005.

  1. Forgotten_1

    Forgotten_1 Registered

    Joined:
    May 23, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    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 :confused:
     
  2. WilliamE

    WilliamE Well-Known Member

    Joined:
    May 14, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  3. Forgotten_1

    Forgotten_1 Registered

    Joined:
    May 23, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    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?
     
Loading...

Share This Page