Is there a way to transfer mysql database from other server to new server with out exporting the database to local machine then import it to new server.
you could set up a master - slave thing. but then the master would have open sockets to the world, probably something you don't want. do you got shell access to both?
is the destination's mysql server is the same version as the sorce..if yes you can just scp the data directory to the destination data directory then ensured that the ownership is correct..then try restarting the mysql server and you will all be good..