Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    156
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Murtaza_t

    Murtaza_t Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    476
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Parahosting

    Parahosting Well-Known Member

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

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice