How can I upload a file to mysql database on shared hosting platform?
The process running on my machine collects data from various websites and stores it in the local mysql database. The same data is exported using SELECT INTO OUTFILE and FTPed to the shared host every few hours. Does my hosting provider not allow LOAD DATA INFILE on shared host? What are my other options for automatic / scheduled loading of MYSQL db on my shared host?
+2
a source to share
2 answers
There are actually many different solutions. You can export the data to INSERT statements and import that SQL file to the server, or import the current outfile dumps with a PHP script instead of using LOAD DATA INFILE, or create a web service that allows you to update the data instead of your current dump / FTP / import script.
+1
a source to share