Adeelarifbhatti-Notes

For migrating LDAP,mysql and store data, go for the following!!!

mkdir /backup

chown zimbra.zimbra /backup su zimbra zmcontrol stop;

/opt/zimbra/libexec/zmslapcat /backup exit mkdir /backup/zim-db-data cp -rp /opt/zimbra/db/data/* /backup/zim-db-data mkdir /backup/zim-logger-db/ cp -rp /opt/zimbra/logger/db/* /backup/zim-logger-db/ mkdir /backup/conf-all cp -rp /opt/zimbra/conf/* /backup/conf-all/ mkdir /backup/detail-database

su zimbra mysql.server start source ~/bin/zmshutil ; zmsetvars mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /backup/mysql.db.list mkdir /backup/detail-database

for db in `cat /backup/mysql.db.list`; do

~/mysql/bin/mysqldump $db -S $mysql_socket -u root --password=$mysql_root_password > /backup/detail-database/$db.sql
     echo "Dumped $db"
          done

mysql.server stop

mkdir /backup/store cp -rp /opt/zimbra/store/* /backup/store mkdir /backup/index cp -rp /opt/zimbra/index/* /backup/index/*

>>>>>>>>>>>>Restoring to new server cp the /backup directory and cp to new server

rm -rf /opt/zimbra/openldap-data/* cp -rp /backup/zim-db-data/* /opt/zimbra/db/data/ /opt/zimbra/openldap/sbin/slapadd -q -b "" -f /opt/zimbra/conf/slapd.conf -cv -l /backup/ldap/ldap.bak cp -rp /backup/conf-all/* /opt/zimbra/conf/

rm -rf /opt/zimbra/db/data/* rm -rf /opt/zimbra/logger/db/*

cp -rp /backup/zim-logger-db/* /opt/zimbra/logger/db/ cp -rp /backup/zim-db-data/* /opt/zimbra/db/data/ cp -rp /backup/store/* /opt/zimbra/store/

>>>>> Restoring mysql

su zimbra source ~/bin/zmshutil ; zmsetvars

for db in `cat /backup/mysql.db.list |grep mbox` do

   mysql -u root --password=$mysql_root_password -e "drop database $db"
   echo -e "Dropped $db"

done

mysql -u root --password=$mysql_root_password -e "drop database zimbra"

for db in `cat /backup/mysql.db.list` do

   mysql -e "create database $db character set utf8"
   echo "Created $db"

done mysql zimbra < /backup/detail-database/zimbra.sql for sql in /backup/detail-database/mbox* do

   mysql `basename $sql .sql` < $sql
   echo -e "Updated `basename $sql .sql` \n"

done exit

mkdir index cp -rp /backup/index/* /opt/zimbra/index/ zmcontrol start