How to restore a broken server

Discussion in 'Installation/Configuration' started by Pida, Sep 6, 2012.

  1. Pida

    Pida New Member

    Hi all from ISP,

    We've had a "small" trouble with mysql master server this night. The server died. But we need to create again all databases what were in a ISPConfig. Is there any way how to create all databases from ISP to new server?
  2. falko

    falko Super Moderator ISPConfig Developer

  3. Pida

    Pida New Member

    Thanks for reply, but my question was about ISPConfig, where the databases were created and managed. How to restore ISPConfig databases informations?
  4. falko

    falko Super Moderator ISPConfig Developer

    What exactly are you trying to do?
  5. Pida

    Pida New Member

    For example:
    1. We'are created many DBs in the ISPConfig (multiserver) on server
    2. In one night our server goes to die :)
    3. So we installed new DB server connected to ISPConfig master.
    4. Now, we need to create again all empty DBs to ISPConfig (master). The same DBs what were on old (died) server.
    5. After that, we can restore all dumps of DBs.

    My question is a how to restore all DBs settings in the ISPConfig. It's same as creating new databases manualy in the ISP, but to other server. But databses are tooooo many.

    Sorry for my english ;-)
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    For a DB server:

    Make a regular backup of all databases on your db server, e.g. with mysqldump plus a backup of the /etc directory and /usr/local/ispconfig. If the db server dies anytime in the future, then just install a new server incl ispconfig but dont connect it to the master server, then restore all databases from your mysqldump files e.g. by simple piping their content to the mysql command and restore the two files form your ispconfig backup and your db server is fully restored and connected again. No need to craete new databases or any other records in ispconfig, just restore the old server from the backup.

    A alternative which micht be even simpler is to use one of the common linux backup softwatre packages, just do a regular backup and restore that wehn your server failed. there is nothing ispconfig specific here as you backup and restore the whole server.

Share This Page