I set up my ISPConfig server. I then added a site. I the downloaded and installed some scripts from PHPJabbers. These install a database. However, this database is not shown by ISPConfig. How can I get this added to the site which is on ISPConfig? I want ISP Config to back both the site and the database. Also I want to replicate the server for redundancy. any idea for easy ways to do this?
Always create databases in ISPConfig if you want them to appear in ISPConfig. Instead of letting such external scripts create databases, create the database and database user in ISPConfig. What you can do now to fix this is dump the database contents with phpmyadmin, then delete the database and database user that was created by these scripts, nor create the database user and database again in ISPConfig, import the SQL dump of the database and then adjust username, password and database name in your script to match the values of the database you created in ISPConfig. You can use the mirroring feature in ISPConfig to replicate web server config on multiple servers, but this rarely makes sense, and in many cases, you will get more downtime due to added complexity than what you would have without that. In most cases, it's wiser to have a decent backup strategy and use virtualization for doing regular snapshots of your system (when you use a cloud server, then that's usually available anyway without extra configuration).
Thank you. The problem is that this is a big database with 180 tables. I dont even pretend to know what half of them do! I am very wary of messing with them as it is most likely to result in me messing something up, which I may well not be able to fix. I was really seeing if there was a easy way, such as a script, so get ISPConfig to add the exisiting database to itself. I can manage it separately but if it were straight forward to add, it would like to do that. Thanks for your help.
then just create a new database and user in ispconfig export the existing database in phpmyadmin and import it into the new database. then just edit the db connection details in the website (copy the existing lines in the config file and adjust the details as needed and then comment out the old lines) the site will start using the new database and the old database is still there as a backup. if there's any problems, just delete the changed db details in the config file and uncomment the old db details. the site is back to using the original db and then you have time to work out what went wrong before trying again. if there's no problems, then after a while just delete the old database.
