1 Topic by PaoloVIP

  • PaoloVIP
  • Member
  • Offline
  • Registered: 2015-08-23
  • Posts: 14

Topic: SQL Backup

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7 MARIADB edition
- Linux/BSD distribution name and version: Debian GNU/Linux 9.3 (stretch)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

About backup_mysql.sh (16/09/2007), default install.

for databases we should backup there are:
export DATABASES=" iredadmin mysql vmail mysql vmail amavisd sogo iredadmin"

Above you can find some ripetitions (are they intentional?) and iredapd db seems missing.

----

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

Re: SQL Backup

Old iRedMail releases had the duplicate database names issue, and iRedAPD doesn't have a SQL db in old (iRedAPD) releases.

You can download the latest version to fix it:
https://bitbucket.org/zhb/iredmail/src/ … ail/tools/

Note: the latest backup_mysql.sh requires file /root/.my.cnf, it doesn't hard-code MySQL root password in the file anymore.