1 Topic by pbf343 (edited by pbf343 2016-02-19 02:50:45)

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 247

Topic: MySQL DB diff

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- 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?
- Related log if you're reporting an issue:
====

Hello

CentOS 6.7
MySQL
iRedAdmin Pro 2.3.1
iRedMail 0.9.4

Performed upgrade on existing machine following instructions.   Also set up new CentOS 6.7 machine and performed new install from scratch with new versions.  Did mysqldump -d --all-databases and compared. 

See some variation in the data outside of the auto-increment values like in Keys, tables, etc.  Appeas some new tables like as well. 

So, what issues and/or procedures do I need in order to migrate to the newly installed system? 

Also noticed some variation in a couple of RPMs with update...  Do the upgrade scripts not correct database and rpms to be identical to new install?

Is there any difference in the database or RPMs between releases of CentOS 6.x vs 7 to consider as well?

----

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: MySQL DB diff

pbf343 wrote:

See some variation in the data outside of the auto-increment values like in Keys, tables, etc.  Appeas some new tables like as well. 

Please show us the differences.

3 Reply by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 247

Re: MySQL DB diff

ZhangHuangbin wrote:
pbf343 wrote:

See some variation in the data outside of the auto-increment values like in Keys, tables, etc.  Appeas some new tables like as well. 

Please show us the differences.

Screenshot of diff with SublimeText - ignore those line numbers to actual file line numbers.

Post's attachments

Screen Shot 2016-02-19 at 6.59.09 AM.png 448.41 kb, file has never been downloaded. 

Screen Shot 2016-02-19 at 7.00.16 AM.png 448.13 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4 Reply by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 247

Re: MySQL DB diff

pbf343 wrote:
ZhangHuangbin wrote:
pbf343 wrote:

See some variation in the data outside of the auto-increment values like in Keys, tables, etc.  Appeas some new tables like as well. 

Please show us the differences.

Screenshot of diff with SublimeText - ignore those line numbers to actual file line numbers.

Are you saying that they should be the same?

Is there any difference between Cent 6 & Cent 7 MySQL database versions with install?

5 Reply by ZhangHuangbin

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

Re: MySQL DB diff

That's the difference between Amavisd-2.6.x (and earlier) and Amavisd-2.7.x.

In old iRedMail releases, we install Amavisd-new (2.6.x) from iRedMail yum repo, but since iRedMail-0.8.5, we install Amavisd from EPEL repo which ships Amavisd-new-2.7.x and newer.

The SQL structure change happened on April 8, 2015:
https://bitbucket.org/zhb/iredmail/comm … visd.mysql

Note: Amavisd-new works fine if you missed some sql columns, because it will simply ignore the columns which don't exist.

For migration, you can use the default "amavisd" database created by iRedMail, and just restore 4 tables on OLD amavisd database: mailaddr, users, policy, wblist. They're used for per-recipient policy lookup and white/blacklists.