1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Mysql LOAD DATA INFILE

Discussion in 'MySQL' started by rederick, Mar 13, 2006.

0
Page 2 of 2
  1. rockarolla

    rockarolla Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #21
    using scripts to import data from text file into mysql table using mysql clause 

     LOAD DATA LOCAL INFILE
    Code (markup):
    is possible only if you can have your mysql user's file_priv set to Y

    that is not allowed by most of the hosting providers ... so look for another option ... on your local computer all privileges are set to yes when you install mysql ... on the server - you can only give certain privileges via cPanel mysql databases ...

    if someone knows more I would be happy to learn a workaround ...
     
    rockarolla, Jul 12, 2008 IP
Page 2 of 2