Zentyal Forum, Linux Small Business Server

Zentyal Server => Installation and Upgrades => Topic started by: endersen007 on April 10, 2013, 12:26:31 pm

Title: Zarafa Migration
Post by: endersen007 on April 10, 2013, 12:26:31 pm

Hello everybody,

I had a big problem after a Zentyal Update (No Answer from Zentyal with the tickets 6348) and the only way to solve the problem was to do a fresh install of Zentyal.

Now my new problem.

I had to re-configure the whole box because the backup was not working at all. So it means the the user ID has changed in the database and I would like to restore all old emails from one Zarafa DB to the other one. These 2 databases are on the same box.
Zarafa Old database : zarafa_old
Zarafa used DB: zarafa

I have found a command to transfer one user mailbox to another with /usr/bin/zarafa-admin --hook-store stored_uid -u username, but how to transfer to one DB to the other one.

Please help.

Cheers

Cédric

Title: Re: Zarafa Migration
Post by: half_life on April 12, 2013, 12:49:25 am

Use mysqldump to take a backup of the old database (or the bench tool).
Edit the dump file with a text editor to change all instances of zarafa_old to zarafa.
Restore the dump as you would any backup.
Get busy reconnecting users ;-)

Title: Re: Zarafa Migration
Post by: endersen007 on April 12, 2013, 08:20:51 am

Thanks half_life,

But my problem is how to restore only one user?

Example:

Username	User ID Old	User ID New
user1	3	7
user2	4	3

The config has changed and the userid too. The zarafa_old is already a mysqldump but with an other config.

Thanks

Cédric