MySQL hosted on Go Daddy no longer supports LOAD DATA LOCALnew local mysql database without root access?How...

In Japanese, what’s the difference between “Tonari ni” (となりに) and “Tsugi” (つぎ)? When would you use one over the other?

Fencing style for blades that can attack from a distance

Email Account under attack (really) - anything I can do?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?

Languages that we cannot (dis)prove to be Context-Free

Why not use SQL instead of GraphQL?

Modeling an IPv4 Address

Is this a crack on the carbon frame?

What does "Puller Prush Person" mean?

How to test if a transaction is standard without spending real money?

"You are your self first supporter", a more proper way to say it

Do I have a twin with permutated remainders?

Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws)

What do you call a Matrix-like slowdown and camera movement effect?

How to find program name(s) of an installed package?

strToHex ( string to its hex representation as string)

Why are electrically insulating heatsinks so rare? Is it just cost?

How could an uplifted falcon's brain work?

Why doesn't H₄O²⁺ exist?

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Problem of parity - Can we draw a closed path made up of 20 line segments...

Risk of getting Chronic Wasting Disease (CWD) in the United States?



MySQL hosted on Go Daddy no longer supports LOAD DATA LOCAL


new local mysql database without root access?How to install SQLite or other DB besides MySQL on hosted server or local XAMPPMySQL Data VisualizationCorrupted MySQL index caused data-loss! How to recover data?Remove data that created by Mysql into outfile?Remove duplicates in column of MySQL dataWhen/why would Chrome get 500 error on localhost but load OK from 127.0.0.1, while Firefox loads both?How to restore mysql database using files on data folder?Docker: Connection PHP/Apache --> MySQL slowmysql remote clients hang, local connections ok






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I had a script that was running on a Go Daddy server. The script was in PHP. On April 2nd something changed at Go Daddy to no longer allow the LOAD DATA LOCAL statement to run. In fact if the SQL statement has that statement it gets the connection dropped.



Is anyone else having this problem?



Any ideas on how to handle bulk data loads other than looping through each record?










share|improve this question







New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • What's the full LOAD DATA LOCAL command you are using within the PHP script?

    – Pimp Juice IT
    yesterday


















0















I had a script that was running on a Go Daddy server. The script was in PHP. On April 2nd something changed at Go Daddy to no longer allow the LOAD DATA LOCAL statement to run. In fact if the SQL statement has that statement it gets the connection dropped.



Is anyone else having this problem?



Any ideas on how to handle bulk data loads other than looping through each record?










share|improve this question







New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • What's the full LOAD DATA LOCAL command you are using within the PHP script?

    – Pimp Juice IT
    yesterday














0












0








0








I had a script that was running on a Go Daddy server. The script was in PHP. On April 2nd something changed at Go Daddy to no longer allow the LOAD DATA LOCAL statement to run. In fact if the SQL statement has that statement it gets the connection dropped.



Is anyone else having this problem?



Any ideas on how to handle bulk data loads other than looping through each record?










share|improve this question







New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












I had a script that was running on a Go Daddy server. The script was in PHP. On April 2nd something changed at Go Daddy to no longer allow the LOAD DATA LOCAL statement to run. In fact if the SQL statement has that statement it gets the connection dropped.



Is anyone else having this problem?



Any ideas on how to handle bulk data loads other than looping through each record?







mysql godaddy load bulk






share|improve this question







New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question







New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question






New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked yesterday









Dave CDave C

1




1




New contributor




Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Dave C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.













  • What's the full LOAD DATA LOCAL command you are using within the PHP script?

    – Pimp Juice IT
    yesterday



















  • What's the full LOAD DATA LOCAL command you are using within the PHP script?

    – Pimp Juice IT
    yesterday

















What's the full LOAD DATA LOCAL command you are using within the PHP script?

– Pimp Juice IT
yesterday





What's the full LOAD DATA LOCAL command you are using within the PHP script?

– Pimp Juice IT
yesterday










0






active

oldest

votes












Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});






Dave C is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421889%2fmysql-hosted-on-go-daddy-no-longer-supports-load-data-local%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes








Dave C is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















Dave C is a new contributor. Be nice, and check out our Code of Conduct.













Dave C is a new contributor. Be nice, and check out our Code of Conduct.












Dave C is a new contributor. Be nice, and check out our Code of Conduct.
















Thanks for contributing an answer to Super User!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421889%2fmysql-hosted-on-go-daddy-no-longer-supports-load-data-local%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...