Remote MySQL transfers

[uk01]

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?

 

[cPanelMichael]

Hello @uk01,

If we have a remote MySQL server What happens if we transfer to/from another cpanel host without remote?

The databases should be created locally on the destination server as part of the transfer process as long as the databases are added to the cPanel accounts on the source server.

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?

It should create the database on the remote MySQL server configured with the destination server. Note that if the source and destination server share the same remote MySQL server, you'll need to manually backup/restore the account until the case referenced on the following thread is solved:

Transfer Tool with shared remote MySQL server

Thank you.