Want to subscribe to topics you're interested in?
Become a Member

MariaDB LOAD DATA INFILE

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by FAPM, Aug 4, 2015.

  1. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    3:50 PM
    1.9.2
    10.0.20
    I have a problem with the function: LOAD DATA INFILE

    I changed the variable local-infile = 1

    But apparently this is not enough.

    Should I make another change?

    Centmin Mod 1.2.3-eva2000.08
     
  2. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    3:50 PM
    1.9.2
    10.0.20
    For me, solved : #fastcgi_param PHP_ADMIN_VALUE open_basedir=$document_root/:/usr/local/lib/php/:/tmp/;
     
  3. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,568
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,748
    Local Time:
    11:50 PM
    Nginx 1.13.x
    MariaDB 5.5
    by any chance was the file doing the loading of data reside outside of your document root ? If so, then yes uncommenting that line will remove open_basedir restrictions :)
     
  4. pritam sinha

    pritam sinha New Member

    12
    2
    3
    Oct 23, 2015
    Ratings:
    +2
    Local Time:
    7:20 PM
    1.9
    5.5
    @FAPM i am having the same problem.
    Can you tell, which file to edit for fastcgi_param PHP_ADMIN_VALUE open_basedir=$document_root/:/usr/local/lib/php/:/tmp/;
     
  5. eva2000

    eva2000 Administrator Staff Member

    28,935
    6,568
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,748
    Local Time:
    11:50 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1