I want a query to copy rows from a table to other table with the same name but in different server.
-
-
it can be done, using php(as i m the php guy, not at all good with DB)
you need to have two databse objects and then using mysql_connect you are able to query both the database and then you can move data to & fro. but make sure the server which you querying remotely should have remote databse access enabled, otherwise it wont allow u to connect from the current server :)
cheers !!
Comment