1 Topic by ired_mania (edited by ired_mania 2021-01-04 18:19:06)

  • ired_mania
  • Member
  • Offline
  • Registered: 2019-06-20
  • Posts: 173

Topic: backup restore Issue

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I have Iredmail0.9.9 and decided to have 1.3.2 on fresh CentOS8.so I should restore backup from current iredmail server . I have some difficulties for restore backup as mentioned in below:


1. how about db structure? according to explaination I should read all the steps from 0.9.9 till latest release and change database structure handy? Is there any script to do that?
(For example, If you're restoring iRedMail from 0.9.1 to 0.9.5, you must check upgrade tutorials for iRedMail-0.9.1 and newer releases, then apply all SQL structure changes mentioned in the upgrade tutorials.)
2. Is there any restore script in source of iredmail? Can I use mysqldump cmd to restore backup? why it notify  mysqldump: could not find table: /tmp/iredadmin-2021-01-02-.sql?
4. how many dbs should be exactly restored?

----

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,088

Re: backup restore Issue

ired_mania wrote:

1. how about db structure? according to explaination I should read all the steps from 0.9.9 till latest release and change database structure handy? Is there any script to do that?

Please check iRedMail upgrade tutorials, they have detailed commands for you to copy-paste.

ired_mania wrote:

2. Is there any restore script in source of iredmail? Can I use mysqldump cmd to restore backup? why it notify  mysqldump: could not find table: /tmp/iredadmin-2021-01-02-.sql?

Just use "mysql" command line to restore it. for example: "mysql iredadmin < /tmp/iredadmin-2021-01-02.sql".

ired_mania wrote:

4. how many dbs should be exactly restored?

iRedMail backups few databases by default: mysql, vmail, roundcubemail, iredadmin, iredapd, amavisd, sogo.

- You should restore all EXCEPT "mysql".
- "vmail" has changes between 0.9.9 and 1.3.2, please follow our upgrade tutorials to apply changes: https://docs.iredmail.org/iredmail.releases.html
- "roundcubemail" has changes too, you must upgrade it too, its own upgrade script will try to apply SQL db changes. https://github.com/roundcube/roundcubemail/wiki/Upgrade
- Both "iredadmin" and "iredapd" have sql changes too, download their latest versions, then upgrade by following tutorials, the upgrade scripts will apply SQL changes too.