I have two servers. I was wondering what happens if I would change the hosted server for database. Does it erase the database on SERVER A and create a new database on SERVER B? Or does it copy the database to SERVER B?
ISPConfig will not copy the data. I´m quite not sure if you will loose the database on the old server. If would like to move a database, i would change the server_id for database in dbispconfig, create a dump using mysql, use resync-tool to create the database and the user on the new server and import the dump.
Probably not in that order, I would create the dump FIRST. I would be too afraid that the script would remove the database before I could get a dump of it.