1 Topic by steveriley

  • steveriley
  • steveriley
  • Member
  • Offline
  • From: Seattle, WA, USA
  • Registered: 2012-06-16
  • Posts: 12

Topic: Switch from PostgreSQL to MySQL

==== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: Debian 7.3
- Related log if you're reporting an issue:
====

For various reasons, I want to change the database on my server from PostgreSQL to MySQL. I found a post here on the forum, from about a year ago, that says this should be easy to do -- just dump all records from one to the other.

http://www.iredmail.org/forum/topic3577 … mysql.html

I'm wondering if this recommendation is still true? Also, I suspect it will be necessary to edit some config files, which ones would those be?

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

Re: Switch from PostgreSQL to MySQL

Still the same, EASY. just dump/backup on old server (PostgreSQL), then import it on new server (MySQL). I suggest you try it on a testing machine first.