Recently I had the fun of researching how to and then importing ~150000 .msg emails into zimbra, this is how I did it.

You will need:

• ubuntu 10.04 LTS
• zimbra 7.1.4 installed
• ssh access to zimbra box (Putty)
• scp access to zimbra box (winscp)
• some common sense

my zimbra 7.1.4 GA Release was running on ubuntu 10.0.4 LTS

The very first zimbra store folder usually belongs to the admin so we need the next* incremented mailbox store id.
this is an example zimbra store for admin:

/opt/zimbra/store/0/1/msg/1

Create a user account that will hold all the emails in zimbra admin panel, then send one email somewhere so zimbra would create a store folder for the account.

Once i have sent one email form the user who will have all the emails imported, zimbra created this store:

/opt/zimbra/store/0/13/msg/0

now we use SCP to copy all the messages to /opt/zimbra/store/0/13/msg/0 , after the copying has finished it might be a good idea to give zimbra full access to these emails.

cd /opt/zimbra/store/0/13/msg/0

sudo chown -R zimbra.zimbra

now we create a folder in zimbra for the user to keep the recovered emails, we will do this in the via putty/ssh.
start zimbra admin

/opt/zimbra/bin/zmmailbox -zadmin

select the user account that will receive all the imported mail

selectMailbox goofy@funkyemailaddress.com

createfolder /Recovery

now we exit zimbra cmd with a Ctrl + C

cd /opt/zimbra/

to begin import

/opt/zimbra/bin/zmmailbox -z -m goofy@funkyemailaddress.com addMessage /Recovery store/0/3/msg/*

if while importing you receive an error about the emails being too large, we increase the size of email messages.

/opt/zimbra/bin/zmprov -z mcf zimbraFileUploadMaxSize 41943040

/opt/zimbra/bin/zmprov -z mcf zimbraMtaMaxMessageSize 41943040

 

Migrating to AD can be a pain, creating new users, migrating the profiles and settings.. oh dear – and keeping your users happy. If you have a small office with about 10 computers/users, there is an easy hack to make the users keep their profiles.

1. The procedure involves you creating the user accounts in AD;
2. Adding the computers to the AD;
3. Giving users full permissions of the profile folder they want to keep so for example “%SystemDrive%\Documents and Settings\andy”
4. Editing the registry;
5. Log in with the new username;

NOTE: these profiles are local computer profiles – they are not roaming profiles.
OK, join the computer to AD and create a username for the computer user, “andy” for example. Now log into that computer as a domain admin and give “andy” full control over “%SystemDrive%\Documents and Settings\andy”

Now log into that computer as “andy” the domain account so he gets a uid generated and a profile created – this will be an empty profile.

Profile generation for AD will create a new profile folder similar to this

"%SystemDrive%\Documents and Settings\andy.000"

Log onto the computer as admin again, now go to start > run > regedit > hit enter:

Now go to: HKLM>Software>Microsoft>Windows NT>CurrentVersion>ProfileList

here you will find all of the profiles on the computer, the nubers indicade uids, find the uid that has the same “ProfileImagePath” variable as your new domain user account for “andy”

"%SystemDrive%\Documents and Settings\andy.000"

now replace this with the local user account profile folder

"%SystemDrive%\Documents and Settings\andy"

Reboot the computer and let andy log in with his domain account, all of the profile settings will be there as before joining AD.

Experiment – may be you find some more hacks.
Please do tell me if anything is unclear.

PHPBB3 – backup & restore tutorial (this tutorial should apply to other forum/bbs on mysql)

For this tutorial we will use several methods to backup and restore mysql databases.

Since you are reading this guide and need to back the database then you may already have a running server or have it hosted somewhere, for those who don’t have a server here is some software to get you hosting.

These downloads are for Windows, but the back up process is more or less universal.

Read more »