What happens to a database when you change the server?

Discussion in 'General' started by fbarcenas, Jul 17, 2015.

  1. fbarcenas

    fbarcenas Member

    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?
     
  2. florian030

    florian030 Well-Known Member HowtoForge Supporter

    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.
     
  3. fbarcenas

    fbarcenas Member

    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.
     
  4. florian030

    florian030 Well-Known Member HowtoForge Supporter

    Changing the server_id using mysql will not trigger any action.
     

Share This Page