dDXeYnAB

1#!/bin/bash
2
3cd ~/mailcow-dockerized
4
5DBUSER=mailcow
6DBPASS=xxxxxxxxxxxxxxxxxxxx
7DBNAME=mailcow
8DBHOST=mailcow.lxd
9
10TBLOLD=mailbox
11TBLNEW=mailbox_new
12IMPORTTBLNAMES="sogo_user_profile alias alias_domain domain domain_admins $TBLNEW quota2 sender_acl"
13
14SSHPASS=xxxxxxxxxxxxxxxx
15
16SQLFILE=~/mailcow_legacy_import.sql
17OLDMAILPATH=root@mailcow.lxd:/var/vmail
18NEWMAILPATH=/var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data
19
20function syncmail {
21 sshpass -p $SSHPASS rsync -azP --delete $OLDMAILPATH/$1/ $NEWMAILPATH/$1/
22 sshpass -p $SSHPASS rsync -azP --delete $OLDMAILPATH/sieve/ $NEWMAILPATH/sieve/
23}
24
25mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "drop table if exists $TBLNEW"
26mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "create table $TBLNEW like $TBLOLD"
27mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "insert $TBLNEW select * from $TBLOLD;"
28
29mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "ALTER TABLE $TBLNEW MODIFY COLUMN tls_enforce_in TINYINT(1) NOT NULL DEFAULT '0' AFTER domain, MODIFY COLUMN tls_enforce_out TINYINT(1) NOT NULL DEFAULT '0' AFTER tls_enforce_in;"
30mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e 'ALTER TABLE '$TBLNEW' ADD COLUMN `kind` VARCHAR(255) NOT NULL AFTER `tls_enforce_out`, ADD COLUMN `multiple_bookings` TINYINT(1) NOT NULL DEFAULT '0' AFTER `kind`, ADD COLUMN `wants_tagged_subject` TINYINT(1) NOT NULL DEFAULT '0' AFTER `multiple_bookings`;'
31
32mysqldump --replace --no-create-info --default-character-set=utf8mb4 \
33 --host ${DBHOST} -u${DBUSER} -p${DBPASS} ${DBNAME} \
34 $IMPORTTBLNAMES > $SQLFILE
35
36mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "drop table $TBLNEW"
37
38sed -i -e 's/'$TBLNEW'/'$TBLOLD'/g' $SQLFILE
39
40source mailcow.conf
41
42docker exec -i $(docker-compose ps -q mysql-mailcow) mysql -u${DBUSER} -p${DBPASS} ${DBNAME} < $SQLFILE
43rm $SQLFILE
44
45#rm $NEWMAILPATH/* -rf
46
47docker-compose exec dovecot-mailcow doveadm quota recalc -A
48
49syncmail /
50
51docker-compose exec dovecot-mailcow doveadm quota recalc -A
52
53docker-compose restart
54
55cd ~