Remote MySQL transfers

If we have a remote MySQL server What happens if we transfer to/from another cpanel host without remote? Also if we transfer between two cpanel servers with remote MySQL does it keep them on remote or copy locally and we need to migrate manually?