3.0 to 4.5.3 Upgrade failed (mysql error)
Hi! I encountered this error while upgrading 3.0 to 4.5.3:
What should I do?
ERROR 1005 (HY000) at line 2: Can't create table './mboxgroup67/#sql-515e_1f1.frm' (errno: 150)
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=SAoo20h4bjrUQusGVKJZ5cQJ8C --database=zimbra --batch --skip-column-names'. at /opt/zimbra/libexec/scripts/Migrate.pm line 220, <OUTPUT> line 94.
Tue Mar 6 11:40:50 2007: Script failed with code 1 - exiting
UPGRADE FAILED - exiting
One more thing, at the start up of the upgrade where it shows my current configuration values, it seems that it cant get the value of my LDAPHOST and LDAPPORT configuration as shown below:
Is this ok?
Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
Possible workaround: Export and Import Accounts and Mails
I've been trying to upgrade my 3.0 installation to the 4.5 (4.5.1 and 4.5.3) for several times for the past month and never succeeded. Im thinking of a possible workaround that will involve the following steps:
1.) Have a fresh install of the latest release (4.5.3) on a different machine, or on a virtual machine
2.) Find a way to import user accounts (and preferences?) from the old server to the new one. Perhaps if I can make their LDAP talk to each other.
3.) Migrate emails via imapsync.
** SINCE THE PRODUCTION SERVER MUST RESIDE ON THE MACHINE OF MY ZIMBRA 3.0**
4.) Backup /opt/zimbra directory from the new server
5.) Install 4.5.3 on the old server, overwriting all the data.
6.) Copy the /opt/zimbra from the new server to the old server (now with a fresh install 4.5.3)
7.) Re-run install.sh (or i can skip this one?)
Are all these possible? Thanks!