Migrate all database from a node to another node of the same ispconfig stack

Dear,
we need to move all customer database from an ispconfig node to another ispconfig node. In order to make remote the database access (we want dedicate a node only to mysql).
We think to procede in the follwing way:

• dump every database from the local node to the external node;
• change the host record on the ispconfig master database in order to point the db on the external node;
• change the connection details of the application from localhost to the remote host;

There is more step to consider? For example we need to add the remote ip address to the mysql user accepted connection to the new mysql database grant? Other than that? The backup feature of ispconfig will continue to work?

 

Yes, we have an ISPConfig installed on the external mysql node.

 

Thank's but we don't wanna recreate manually the databases (are >100). But automatically move all the database from the localserver to the remote one. Is for that, that we'd like to procede how we have described on the first post. If is it possible.

 

mmmh...so before I need to modify the server_id of db/user on ispconfig then resync the data on the new server, and then reimport the dump of all databases on the new server?

In that way my procedure change in this way:

• dump every database
  
• change server_id of db/user on ispconfig
• resync mysql on new node (the same node of the server_id changed before)
• import dump of every database on the new node
  
• change the host record on the ispconfig master database in order to point the db on the external node;
• change the connection details of the application from localhost to the remote host;

Is that correct?

ty