HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   How to restore a broken server (http://www.howtoforge.com/forums/showthread.php?t=58569)

Pida 6th September 2012 15:20

How to restore a broken server
 
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?

falko 7th September 2012 15:55

You can create MySQL dumps...

http://www.howtoforge.com/faq/6_3_en.html

... and restore them on the new server:

http://www.howtoforge.com/faq/6_4_en.html

Pida 7th September 2012 16:02

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

falko 8th September 2012 11:27

What exactly are you trying to do?

Pida 9th September 2012 12:48

For example:
1. We'are created many DBs in the ISPConfig (multiserver) on server mysql1.example.com.
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 ;-)

till 10th September 2012 08:47

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 config.inc.php 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.


All times are GMT +2. The time now is 05:02.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.