Old 16th September 2011, 00:35
ecomark ecomark is offline
Junior Member
Join Date: Sep 2011
Location: Göteborg
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple Server Migration

I work for a web hosting provider and I am trying to write a program to migrate multiple ispcofig instances to a single ispconfig target.

I'm think I understand the problem. First we have to transfer multiple dbispconfig databases (on a per client basis) from the source systems to one target system. Then it's a matter of migrating the content. It is the first of these that poses the greatest problem for me.

The main problem I am encountering is database relationships and ids.

Is there any documentation outlining the column definitions for the tables in the dbispconfig database, and what the table ids point to?

Exporting and importing each database is obvoiusly not good enough because the relationships would be screwed up. What I am working on is an intelligent way of working out which web domains, which email domains and mailboxes, which ftp accounts, which alias domains, which ssh accounts (it goes on!) are hierarchically subordinate to a single client (or reseller) and moving those from one system to another using a combination of the ispconfig api and mysql calls.

It would be a project we are willing to share, but to speed things up it would help no end to know some more about how the ispconfig database works without having to do shit loads of reverse engineering. A lovely schema chart with arrows describing all the relationships would be my dream, but I am aware that this might not exist.

If anyone has ideas, knows who would be the best person in the ispconfig team to contact, knows of a similar project, or just feels like exploring themselves, then please post.

Good night from Gothenburg,

Reply With Quote
Sponsored Links
Old 16th September 2011, 02:23
xaver xaver is offline
Join Date: May 2009
Posts: 77
Thanks: 10
Thanked 25 Times in 14 Posts


i would remove all prefixes and use API to setup new databases and ...
-> sync, mirror db ...

Reply With Quote


database, migrate, migration

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
User unknown in relay recipient table Taxick Installation/Configuration 12 9th April 2013 13:31
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Centos5.4/ISPConfig 3--Virtual site not working MichaelCaditz Installation/Configuration 25 25th March 2011 12:37
Email problem 'Cannot set my user or group id.' (using ISPConfig 3 + OpenSuSE 11.2) urosm Installation/Configuration 5 19th June 2010 23:41
Sending mail ISPConfig 3 but not receivind catza Installation/Configuration 20 19th May 2010 13:47

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

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