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.

Users can't import mySQL databases. ._.;

Discussion in 'General Discussion' started by Parahosting, Apr 10, 2007.

  1. Parahosting

    Parahosting Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    Users cannot import mySQL databases such as wikimedia databases. Example query run in phpmyadmin(SQL Import):

    Code:
    
    CREATE TABLE `wiki_categorylinks` (
    `cl_from` int( 8 ) unsigned NOT NULL default '0',
    `cl_to` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
    `cl_sortkey` varchar( 86 ) COLLATE utf8_bin NOT NULL default '',
    `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
    UNIQUE KEY `cl_from` ( `cl_from` , `cl_to` ) ,
    KEY `cl_sortkey` ( `cl_to` , `cl_sortkey` ) ,
    KEY `cl_timestamp` ( `cl_to` , `cl_timestamp` )
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
    
    MySQL said: Documentation
    #1071 - Specified key was too long; max key length is 1000 bytes 
    
    I tried searching for a key length in /etc/my.cnf, but nothing of the sort is in it.

    My current mySQL version is 5.0.24, and phpmyadmin version if it matters, is what comes with cPanel.
     
  2. Murtaza_t

    Murtaza_t Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    476
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    cPanel Access Level:
    Website Owner
    I have had this problem with one of my client.. It is a bug in MySQL5..

    The fix is available HERE

    Hope that it helps.
     
  3. Parahosting

    Parahosting Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    So this means I have to do this for every table? =/;
     
Loading...

Share This Page