Zarafa Migration

[endersen007]

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

[half_life]

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 ;-)

[endersen007]

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