#1  
Old 15th September 2011, 23:35
ecomark ecomark is offline
Junior Member
 
Join Date: Sep 2011
Location: Gteborg
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,

Mark
Reply With Quote
Sponsored Links
  #2  
Old 16th September 2011, 01:23
xaver xaver is offline
Member
 
Join Date: May 2009
Posts: 77
Thanks: 10
Thanked 24 Times in 14 Posts
 
Default

Hi,

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

regards
xaver
Reply With Quote
Reply

Bookmarks

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


All times are GMT +2. The time now is 10:55.


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