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 problem: LOAD DATA LOCAL INFILE

Discussion in 'General Discussion' started by leorevenda, Jun 21, 2005.

  1. leorevenda

    leorevenda Active Member
    PartnerNOC

    Joined:
    Jan 24, 2004
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I install cpanel on a new server yesterday, but mysql don't accept LOAD DATA LOCAL INFILE, I tray to configure my.cnf but don't have sucess on activate this option, anybody can help-me?

    Error is:

    The used command is not allowed with this MySQL version

    Cpanel/linux verions:
    WHM 10.1.0 cPanel 10.2.0-R82
    CentOS 3.5 i686 - WHM X v3.1.0


    Thanks

    Leo
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    The first option may well be to check the MySQL documenation to check what MySQL version is required for the command you are trying to use and check what version of MySQL you are running, and possibly upgrade if necessary.
     
  3. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    The following page of the MySQL docs includes plenty of info:

    http://dev.mysql.com/doc/mysql/en/load-data.html

    In particular:
     
  4. leorevenda

    leorevenda Active Member
    PartnerNOC

    Joined:
    Jan 24, 2004
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Thanks, is stranger problem, script and sintax are correct, work normally before we format server and make a reinstall on the new server.

    mysql is 4.0.24, upgrade to 4.1.X is good ideia?

    Thanks
     
  5. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Since the only version-specific issue I could find in the docs relates to MySQL < 4.1, it is possible that an upgade would sort things out. However this is only a guess.

    If you do choose to upgrade, make 112% sure you backup all databases before hand as if something goes wrong, you can't just downgrade from 4.1 to 4.0 and expect things to work.
     
  6. DigitalN

    DigitalN Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    420
    Likes Received:
    1
    Trophy Points:
    18
    Put a phpinfo() into a cpanel theme directory and view it.
    Look at which mysql libraries cpanels php is using.

    eg. /usr/local/cpanel/base/frontend/x/phpinfo.php

    PHP:
    <? phpinfo();?>
    --with-mysql=/usr should be seen in the phpinfo()

    If not., you might need to recompile cpanels php /usr/local/cpanel/3rdparty/bin/php to use the libraries in /usr.
     
Loading...

Share This Page