Load in mysql data transfer from one server to another and one more issue
Posted on 2015-01-29
I have two queries due to geo location of my servers
php scripting language
1> I have mysql on one server and php code on other server.
I save the csv file on both the server .
If file is saved on script side and executed the code works fine .
"LOAD DATA LOCAL INFILE "/var/www/pathofcsv file of mysql server" INTO TABLE" this code is executed from php server even replaced it with path of php server but result failed.
2 > Other issue is that my client is unaware to do upload part. so the offline software which is running on his windows server would dump the file in one of the decided folder from where i have to pick up the above file after regular interval
i was thinking to write a window batch file which would read if some file are dump in the desired location and then upload it on server. Please suggest if there is any other better solution as i tried to such code but failed or please provide the script if readily available