1 Topic by awoldman

  • awoldman
  • Member
  • Offline
  • Registered: 2020-02-03
  • Posts: 6

Topic: Upgrade to current ired from .99 - mysql question

I am looking to fix an issue with our ired server
Its stuck on .99 do to an issue with the version of freebsd its on.  (12.0 daily not live)

I have tried updating freebsd and ports to current on a snapshot of it but the ports get mangled each time.

So now, I am looking to swing migrate it to a freshly installed ired on a current live Freebsd.

Can I add just the mysql field updates to the live .99 server without breaking things.

Or, would migrating the .99 server mysql to the current test server running 1.51 and then updating the mysql tables work ok.
It looks like most of them are just adding a few new fields not changing existing.

Thanks

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: Upgrade to current ired from .99 - mysql question

Try this:

- Setup a testing machine with the latest iRedMail (1.5.1 today), rename the "vmail" database to, e.g. "vmail_new".
- Dump "vmail" database on old (production) iRedMail server and import it on testing machine. Now you have the old "vmail" database on new server.
- Apply SQL structure changes by following iRedMail upgrade tutorials. Then you should get the same SQL structure as the latest iRedMail. FYI: https://docs.iredmail.org/iredmail.releases.html

You can use this updated "vmail" database on new server.

3 Reply by awoldman

  • awoldman
  • Member
  • Offline
  • Registered: 2020-02-03
  • Posts: 6

Re: Upgrade to current ired from .99 - mysql question

Thank you.  Turns out I was so close. 
I had to drop the vmail table and recreate it before importing.
Once I did that it just worked.



ZhangHuangbin wrote:

Try this:

- Setup a testing machine with the latest iRedMail (1.5.1 today), rename the "vmail" database to, e.g. "vmail_new".
- Dump "vmail" database on old (production) iRedMail server and import it on testing machine. Now you have the old "vmail" database on new server.
- Apply SQL structure changes by following iRedMail upgrade tutorials. Then you should get the same SQL structure as the latest iRedMail. FYI: https://docs.iredmail.org/iredmail.releases.html

You can use this updated "vmail" database on new server.