ISPConfig Server Migration -- howto??

Discussion in 'Installation/Configuration' started by crypted, Jan 15, 2008.

  1. crypted

    crypted Member

    We are running on an old and outdated server. We are curious if there's a way to migrate the ISPConfig system (websites, databases, users, and all) over from one server to another? IF so, how would we go about doing so? Thanks!
     
  2. Hans

    Hans Moderator Moderator

  3. crypted

    crypted Member

    that's a great thread. however, there's still more that i do require having done. i will be losing all of my original 10 ips that the websites are using. is there a way to process 10 new ips into the system without having to go to each site and each dns file and manually edit them to include such new ips?

    I.E. ips 207.150.163.130-207.150.163.139 will be forced to become 207.150.164.120-207.150.164.120.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Add the new IP addresses in ispconfig under management > server > settings. Then replace the IP addresses in the isp_isp_web tabble with sql commands (via phpmyadmin) after you migrated the system. Then execute the sql statement:

    update isp_isp_web SET status = 'u' WHERE status = '';

    and change one site manually in the interface. Now all sites will get updated.

    You can do the same for the dns_* database tables. The table with the sttaus field is dns_isp_dns in this case.
     
  5. crypted

    crypted Member

    thanks...

    anyone know a shortcut for dropping ALL mysql databases at once from the command line and then restoring them at once? i can't figure it out but i did it a long long time ago... ugh.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    The easiest way is:

    1) Stop the mysql server.
    2) Copy all directories from within /var/lib/mysql/ to the new server except of the directory called mysql. The directories have the names of the databases and contain everything related to the database.
     
  7. crypted

    crypted Member

    That will also copy the usernames and passwords for the sql databases?
     
  8. falko

    falko Super Moderator Howtoforge Staff

    No, these are in the mysql database (in the user and db tables). You'd have to copy the missing records manually (using SQL statements).
     

Share This Page