Dear All, We are using mysql database in CENTOS server and Fedora server. All are mysql 5.0. We have 2 server in 2 different locations. Now we want to take backup of mysql database from 1 end and need to transfer this to another end and need to extract the data and use it. In 1 end we dont have the fixed ip(Global ip). So can i write shell script to make back and trasnfer to any ftp location from 1 end. In another end can read from ftp and extract the data. Now need to do the process once in 30 mts interval. How to do this can any one help me to fix this. Very urgent. Thanks & Regards Saravanan.
If, for some reason, you can't do what falko suggested and have PHP as well as access to the crontab on Server2 you should look into the cURL-Library. With this you can do downloads on Server2(no fixed ip) connecting to Server1(fixed ip), by placing a PHP-Script on Server2. It works well, but obviously with the limitations of being a file transport via a ftp connection. cURL also allows for other types of connection by the was http://php.net/manual/en/book.curl.php Check your PHP-Info to see if you got cURL support enabled. Cheers
