how to make a copy of a database from remote server to our own server?

php4om

I am making a site where the requirement is take the data from different databases from different servers.
site which i am making - every thing is based on third party databases and tables so first we need to know how to access and connect databases and files from the remote server. Here we are not connecting from remore server in real time every thing will be store in our server, but we are copying database from remotes servers to our servers time to time. one more important thing is during the list and search we have to take (fetch) the data from our different databases which is updating in a regular interval in our server. Not only that i have to fetch all folder and image file they have uploded.
Please give us a solid suggestion and if possible please give us some reference to fetch the data (images,.ipx and other type of data) and databases from different servers.

Please help me here the problem is that how to connect from the remote server and take the databases as well as other files in our server.
i don't know how it is possible.

thanks 🙂

AstroTeg

Kind of like this post which I already responded to: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10294334

Ok, here's what you do:

Research your databases you are using. Find out how to import and export from them. Write some scripts to do the importing and exporting. And you're all set.

php4om

see here the problem is that we just can not expoer and import database we have to fetch every thing related to that record.

so only knowing export and import won't work.
another thing is how to access some other database after thier permition or after paying them. is ther any way ? we have to update database in our server after a regulat interval.
how to do this, this is possible by php or not.

thanks

AstroTeg

Can you have one script talk to both databases? If so, you have one script pull out the records and port them over to the 2nd database. This is just an exercise in querying and inserting.

If you can't have one script access both databases, then you'll have to create two scripts. One script for each database. One script will be tasked with pulling data out of a database and the other script will be responsible for importing that data. The format can be whatever you choose. You'll be responsible for creating the format and then saving and reading data to that format.

Can PHP do this? Yup. It'll require some coding, but as long as it can talk to the databases, there's nothing stopping it...