$CONF['database_type'] = 'mysql'; $CONF['database_host'] = 'localhost'; $CONF['database_user'] = 'mail-admin'; $CONF['database_password'] = 'admin7785'; $CONF['database_name'] = 'mail';
mail-admin@mail:~$ mysqldump -u root -p mail > maildb_backup_20170825.sql Enter password: <---- mysqladmin
mysql> use mail; mysql> show tables; +-----------------------+ | Tables_in_mail | +-----------------------+ | admin | | alias | | alias_domain | | config | | domain | | domain_admins | | fetchmail | | log | | mailbox | | quota | | quota2 | | vacation | | vacation_notification | +-----------------------+ mysql> describe mailbox; +------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | NULL | | | password | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | NULL | | | quota | bigint(20) | NO | | 0 | | | local_part | varchar(255) | NO | | NULL | | | domain | varchar(255) | NO | MUL | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +------------+--------------+------+-----+---------------------+-------+ mysql> select * from mailbox; +------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+ | username | password | name | maildir | quota | local_part | domain | created | modified | active | +------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+ | munakata@hmuna.com | $1$9975d93d$7uKDdKNnb6DAYdugiIWeN0 | hisao munakata | munakata@hmuna.com/ | 0 | munakata | hmuna.com | 2014-07-04 00:50:46 | 2014-07-04 00:50:46 | 1 | | mail-admin@hmuna.com | $1$773730f1$tE55MxG5mxTZPrYETPJcK0 | mail admin | mail-admin@hmuna.com/ | 0 | mail-admin | hmuna.com | 2014-07-04 00:50:04 | 2014-07-04 00:50:04 | 1 | | public_mail@hmuna.com | $1$045a718c$7weHeSb7EN0EtnV14e1xF. | hisao munakata | public_mail@hmuna.com/ | 0 | public_mail | hmuna.com | 2014-07-04 00:51:24 | 2014-07-04 00:51:24 | 1 | | server-admin@hmuna.com | $1$7f1c42b7$UzPUtxsgMAwwHpB3G40Ay0 | server admin | server-admin@hmuna.com/ | 0 | server-admin | hmuna.com | 2014-07-04 00:51:48 | 2014-07-04 00:51:48 | 1 | | yuko@hmuna.com | $1$4b287f90$7Zott.IlT053.SxHveM.M0 | yuko | yuko@hmuna.com/ | 0 | yuko | hmuna.com | 2014-07-04 00:52:50 | 2014-07-04 00:52:50 | 1 | | purple@hmuna.com | $1$2c52aa21$9a0F8dRCzBWrebrJriY5r/ | yuko | purple@hmuna.com/ | 0 | purple | hmuna.com | 2014-07-04 00:53:17 | 2014-07-04 00:53:17 | 1 | +------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+
[AWS] ubuntu:~$ mysql -umail-admin -padmin7785 mail < maildb_backup_20170825.sql
−− postfixadmin setup password = admin7785
$CONF['setup_password'] = '7a2fe61fbf7489dd008233a32adda46e:02d599a3ae5255b7993dcaaf52f4df1aeeb64c5f';