Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th June 2010, 16:50
kardac kardac is offline
Junior Member
 
Join Date: Jun 2010
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via ICQ to kardac Send a message via AIM to kardac Send a message via MSN to kardac Send a message via Yahoo to kardac Send a message via Skype™ to kardac
Default export/import of mailuser using db

Hi.

I have installed a new ISPconfig 3 server to replace my old one. Due to different reasons i dont want to keep anything of the old settings except the mailsetting.

If i want to export all old mailaccounts with e-mails is it enough to export the mail_ tables and import them to the new servers dbispconfig?

Something i need to think about before i do this (except backup)?


Thanx for a great product!

Last edited by kardac; 27th June 2010 at 17:11.
Reply With Quote
Sponsored Links
  #2  
Old 27th June 2010, 18:57
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

This is possible for the email part. Export and import the email tables and then copy the file structure in /var/vmail from the old to the new server. If any of the email accounts are assigned to a client, you will have to export and import the client, sys_user and sys_group tables too.

Just as a note for other readers of this thread. This export works only for the mail users, it will not work for websites or DNS records.
__________________
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:
kardac (27th June 2010)
  #3  
Old 27th June 2010, 20:32
kardac kardac is offline
Junior Member
 
Join Date: Jun 2010
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via ICQ to kardac Send a message via AIM to kardac Send a message via MSN to kardac Send a message via Yahoo to kardac Send a message via Skype™ to kardac
Default

Quote:
Originally Posted by till View Post
This is possible for the email part. Export and import the email tables and then copy the file structure in /var/vmail from the old to the new server. If any of the email accounts are assigned to a client, you will have to export and import the client, sys_user and sys_group tables too.
Thanx for the answer. The e-mail accounts is assigned to a client, if i dont import the client, sys_user and sys_group tables, wont the e-mail accounts show up in ISPconfig?

I have already created the client and assigned a site and isntalled an CMS there so i risk overwrite the new data if i import the client I guess


Br,
Kardac
Reply With Quote
  #4  
Old 28th June 2010, 10:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
 
Default

Quote:
Thanx for the answer. The e-mail accounts is assigned to a client, if i dont import the client, sys_user and sys_group tables, wont the e-mail accounts show up in ISPconfig?
They will probably show up for the admin but will trow errors when you edit them.

The only other thing that you can do is to edit the sys_userid, sys_groupid odf all records that you import to match a existing user and group in the new datbase (e.g. userid 1 and groupid 1 for the admin user).
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
dbispconfig, export/import, phpmyadmin, postfix

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
Mailuser interface Horfic Plugins/Modules/Addons 497 28th November 2013 10:01
Procedure: changing a mailuser password Hans General 14 22nd September 2008 17:21
Enable/Disable mailuser login, per user madmucho Feature Requests 0 18th September 2008 09:14
ISPConfig 2.2.24 | mailuser app bug? Hans General 19 4th August 2008 15:18
Deleting a mailuser does not work completely viewport Installation/Configuration 4 7th March 2006 04:44


All times are GMT +2. The time now is 07:58.


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