2

A process running on my machine collects data from various websites and stores it in the local mysql db. Same data is exported using SELECT INTO OUTFILE and FTPed to the shared host every few hours. My hosting provider doesn't allow LOAD DATA INFILE to be executed on the shared host? What are my other options for automated/scheduled load to MYSQL db on my shared host?

Improve this question

2 Answers 2

Reset to default
1

There's lots of different solutions actually. You could export the data as INSERT statements and import that SQL file on the server, or import your current outfile dumps using a PHP script instead of using LOAD DATA INFILE, or create a webservice that allows you to update the data instead of your current dump/FTP/import scenario.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I don't want to do it one row at a time using INSERT. My shared hosting doesn't allow LOAD DATA INFILE within PHP script.
1

I found an excellent solution on this webpage.

Improve this answer

2 Comments

Page does not exist
Link broken. Avoid this type of answer, at least give a summary of the solution

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.