[help] How to import database from url?

Hi,

I have mysql database uploaded on another host let's say www.myhost1.com/files-to-import.sql

Is there anyway that I can use this files-to-import.sql to update mysql database on www.myhost2.com?

Thanks

 

If you have SSH access, just wget the file and then do the mysql import via the command line. Otherwise, why don't you just download it and then upload it to PHPmyadmin?

 

yes i can just download it and upload it if only i have one site to manage.. But I have few sites to manage and the file is 20mb so download and upload it is a big problem for me. If I have to do it on 20 hosts that would be 800 mb to download and upload.

Besides I don't know how to command on shared hosting.

Is it possible to do copy image from url like photobucket do where we just have to insert the image url to copy.

 

i think this is going to be one hell of a job to do..

 

if u have ftp access to where the sql is hosted, you can use http://www.net2ftp.com/ to import directly to the other host

 

Check this out , the last post has a neat solution http://forums.tizag.com/archive/index.php?t-3581.html