Looks like it was a duplicate key. I did setup a test account to make sure zimbra was working before doing the restore, you think that caused it? The account that caused the error was one that only existed in the backup and was not present on the fresh copy of zimbra.
So next time I do this, I should delete all the auto-created accounts out of zimbra before starting the restore process?
Caused by: com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 258
... 29 more
Caused by: java.sql.SQLException: Duplicate entry '258' for key 1
Query being executed when exception was thrown:
com.mysql.jdbc.ServerPreparedStatement - INSERT INTO mailbox1.mail_item(id, type, parent_id, folder_id, index_id, imap_id, d
ate, size, volume_id, blob_digest, unread, flags, tags, sender, subject, metadata, mod_metadata, change_date, mod_content) VALUES(
258, 14, null, 257, 258, 258, 1186588643, 748, 1, 'Q2qBUNVSGqXtn70PgzeK5JN8vOM=', null, 0, 0, null, '_Template', 'd2:ct24:text/htm
l; charset=utf-83:revld2:cr23:email@example.com:f0:2:rdi1186588643611e3:ridi5e2:rsi748e3:veri1eee1:vi9e2:ww9:_Templatee', 5
, 1186588643, 5)