/ Register

Join the community today
Become a Member

MariaDB LOAD DATA INFILE

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

Previous Thread Next Thread
Loading...
  1. Aug 4, 2015 #1
    FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:16 AM
    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. Aug 4, 2015 #2
    FAPM

    FAPM Member

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

    eva2000 Administrator Staff Member

    55,190
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    2:16 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Nov 17, 2015 #4
    pritam sinha

    pritam sinha New Member

    12
    2
    3
    Oct 23, 2015
    Ratings:
    +2
    Local Time:
    9:46 AM
    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. Nov 17, 2015 #5
    eva2000

    eva2000 Administrator Staff Member

    55,190
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    2:16 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
Previous Thread Next Thread
Loading...

.