#1  
Old 6th September 2012, 15:20
Pida Pida is offline
Junior Member
 
Join Date: May 2012
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Question 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?
Reply With Quote
Sponsored Links
  #2  
Old 7th September 2012, 15:55
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 7th September 2012, 16:02
Pida Pida is offline
Junior Member
 
Join Date: May 2012
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Thanks for reply, but my question was about ISPConfig, where the databases were created and managed. How to restore ISPConfig databases informations?
Reply With Quote
  #4  
Old 8th September 2012, 11:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What exactly are you trying to do?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 9th September 2012, 12:48
Pida Pida is offline
Junior Member
 
Join Date: May 2012
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Default

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 ;-)
Reply With Quote
  #6  
Old 10th September 2012, 08:47
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,507
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Pida (10th September 2012)
Reply

Bookmarks

Tags
ispconfig, mysql, restore, server

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
500 internal error after upgrade abintipl Installation/Configuration 9 18th July 2012 12:51
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
ISPConfig3 mail doesn't work Marr General 6 1st September 2010 09:32
Webmail Relay Error palkat General 17 23rd April 2006 18:12


All times are GMT +2. The time now is 19:14.


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