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?
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
Thanks for reply, but my question was about ISPConfig, where the databases were created and managed. How to restore ISPConfig databases informations?
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 ;-)
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.
