MySql - Import .sql file on web url via PHP

[bux23]

Hello,

 

I am looking for a php script to import a .Sql file that is in a  specific url (like: http://www.dropbox.com/s/xxxx/file.sql)

to MySql DB.

 

Thanks

[requinix]

Is this not something you can just do manually? Not many good reasons why you should be able to execute arbitrary SQL files on a regular basis. Fewer that require you to use PHP instead of, say, a cronjob.

[bux23]

I need my online server to update from a sql file I automatically export to my dropbox periodically with a cronjob.  So i need a script on server side that imports that file, also with a cronjob.

 

nyone can help me with the code? I have problems accessing the file from web url.

[ginerjm]

Trying to understand your problem.

 

You are looking for a php script that you can run to grab a .SQL file (a file containing some sql statements?) and then execute that sql code to update your db table(s). This sql file is created by some process outside your control I presume, otherwise why would you not just simply do the update instead of saving and retrieving this sql code from the .SQL file?

 

Is that accurate?