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 ...