Results 1 to 6 of 6

Thread: [SOLVED] Zimbra 7 nach Upgrade: Database Integrity check report

  1. #1
    matthias.ue is offline Junior Member
    Join Date
    Apr 2011
    Posts
    6
    Rep Power
    4

    Default [SOLVED] Zimbra 7 nach Upgrade: Database Integrity check report

    Hi,
    wir haben letzte Woche von Zimbra 6 auf 7 aktualisiert. Nun haben wir heute morgen eine Mail vom Server bekommen mit folgendem Inhalt:

    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=****************************
    mboxgroup1.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup1.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup1.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup1.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup1.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup10.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup10.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup10.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup10.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup10.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup11.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup11.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup11.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup11.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup11.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup12.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup12.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup12.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup12.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup12.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup13.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup13.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup13.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup13.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup13.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup14.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup14.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup14.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup14.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup14.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup15.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup15.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup15.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup15.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup15.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup16.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup16.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup16.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup16.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup16.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup17.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup17.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup17.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup17.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup17.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup18.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup18.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup18.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup18.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup18.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup19.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup19.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup19.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup19.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup19.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup2.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup2.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup2.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup2.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup2.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup20.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup20.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup20.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup20.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup20.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup21.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup21.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup21.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup21.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup21.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup22.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup22.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup22.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup22.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup22.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup23.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup23.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup23.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup23.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup23.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup24.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup24.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup24.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup24.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup24.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup25.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup25.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup25.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup25.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup25.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup26.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup26.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup26.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup26.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup26.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup27.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup27.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup27.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup27.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup27.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup28.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup28.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup28.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup28.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup28.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup29.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup29.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup29.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup29.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup29.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup3.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup3.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup3.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup3.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup3.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup30.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup30.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup30.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup30.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup30.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup4.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup4.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup4.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup4.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup4.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup5.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup5.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup5.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup5.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup5.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup6.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup6.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    mboxgroup6.imap_folder
    error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
    mboxgroup6.mail_item
    error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
    mboxgroup6.pop3_message
    error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
    mboxgroup7.appointment
    error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
    mboxgroup7.data_source_item
    error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
    Das geht noch ein Stück so weiter, ich kürze es mal ab wegen der Zeichenbeschränkung hier im Forum.
    Ich habe hier im Forum schon ein wenig geschaut und auch einen Beitrag gefunden:

    [SOLVED] Database Integrity check report

    Die dort benutzten Befehle funktionieren aber nicht. Dort kommt beim Versuch folgende Fehlermeldung:

    zimbra.volume
    note : The storage engine for the table doesn't support repair
    Der Betreiber unseres Servers vermutet das es InnoDB Tabellen sind.

    Ich hoffe mir kann jemand helfen.

    Vielen Dank

    MfG
    Matthias

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,504
    Rep Power
    57

    Default

    Please read the Release Notes on what you need to do after an upgrade to ZCS 7 or search the forums for the error message.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    FritzBrause is offline Partner (VAR/HSP)
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    Guten Morgen,

    das Upgrade auf 7.x ändert die MySQL Version auf 5.1. Entsprechend der Release Notes ist nach dem Upgrade das entsprechende MySQL Konvertierungsscript aufzurufen, um die Datenbanktabellen anzupassen:

    "MySQL table upgrade is required after upgrading to ZCS 7.0. MySQL table upgrades are not automatically run during the upgrade to 7.0 based on time that it takes this process to run. There are no known performance impacts of running in production without doing this MySQL table upgrade. Customers can avoid these errors in the zmdbintegrityreport output by executing /opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl"

    P.S. Es wäre hilfreich, das Nutzerprofil entsprechend zu vervollständigen: "zmcontrol -v", damit man auch fundiert antworten kann.
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  4. #4
    matthias.ue is offline Junior Member
    Join Date
    Apr 2011
    Posts
    6
    Rep Power
    4

    Default

    Ich habe die Arbeiten jetzt von unserem Hoster ausführen lassen.
    Hier das Ergebnis:
    Update-DB-Script zeigt am Ende:
    Adding zimbra.mobile_devices to be optimized
    ..Tue Apr 12 08:51:33 2011: DB: ALTER TABLE zimbra.mailbox ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

    Tue Apr 12 08:51:36 2011: DB: ALTER TABLE zimbra.volume ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

    Altered 31 mailbox groups in 119 seconds

    und das Testscript dann:
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxxxxxxxxxxxxxxxxxxxxxxxx
    mysql.general_log
    Error : You can't use locks with log tables.
    mysql.slow_log
    Error : You can't use locks with log tables.
    Sieht ja schon mal besser aus als Vorher
    Ich würde sagen ich lasse das jetzt erst mal so. Der Server läuft und keine Beschwerden bis jetzt

    Vielen Dank

    MfG
    matthias

  5. #5
    FritzBrause is offline Partner (VAR/HSP)
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    ... die beiden Meldungen kann man ignorieren. Siehe: http://www.zimbra.com/forums/install...s-ose-7-a.html
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  6. #6
    juliocs is offline Starter Member
    Join Date
    May 2012
    Posts
    2
    Rep Power
    3

    Default Upgrade zimbra 6.0.6 para 7.2 (Migração mysql zimbra 7.2)

    Reparar o erro abaixo:

    Realizar o upgrade das tabelas:
    error: Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!

    Servidor atual
    mysql.server start
    source ~/bin/zmshutil ; zmsetvars

    /opt/zimbra/mysql/bin/mysqldump --user=root --password=$mysql_root_password --socket=$mysql_socket --all-databases --single-transaction --flush-logs > /opt/zimbra/backup/dump-atual.sql

    Copiar o dump realizado para o servidor backup
    scp /opt/zimbra/backup/dump-atual.sql 192.168.254.253:/opt/zimbra/backup/

    Realizar o backup da pasta db
    cd /opt/zimbra
    cp -a db db.back

    Parar o serviço do zimbra
    su zimbra -c “zmcontrol stop”

    Remover a pasta zimbra e todas as mboxgroup
    rm -rf /opt/zimbra/db/data/zimbra
    rm -rf /opt/zimbra/db/data/ mboxgroup*
    Iniciar o banco mysql
    mysql.server start

    Importar o backup
    mysql < /opt/zimbra/backup/dump-backup.sql

    Servidor Backup

    Instalar a mesma versão do zimbra em outro servidor.
    Restaurar o backup no novo servidor.
    mysql < /opt/zimbra/backup/dump-atual.sql

    Fazer o dump do banco.

    /opt/zimbra/mysql/bin/mysqldump --user=root --password=$mysql_root_password --socket=$mysql_socket --all-databases --single-transaction --flush-logs > /opt/zimbra/backup/dump-backup.sql

    Copiar o dump realizado do servidor de backup para o servidor atual.
    scp /opt/zimbra/backup/dump-backup.sql 172.16.0.2:/opt/zimbra/backup/

    Copiar a pasta zimbra do outro servidor.
    scp -r /opt/zimbra/db/data/zimbra 172.16.0.2:/opt/zimbra/db/data/
    scp -r /opt/zimbra/db/data/mboxgroup1 172.16.0.2:/opt/zimbra/db/data/

    Servidor atual

    Iniciar o zimbra
    su zimbra -c “zmcontrol start”

    Listar um mailbox

    mysql -e 'SHOW tables FROM mboxgroup3'
    mysql -e "check table mboxgroup100.mail_item"
    mysql -e "check table zimbra.mailbox"

    CHECAR A INTEGRIDADE
    /opt/zimbra/libexec/zmdbintegrityreport -v

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Upgrade to Zimbra 7 - Table upgrade required
    By n8bounds in forum Administrators
    Replies: 10
    Last Post: 04-25-2011, 11:07 PM
  2. Replies: 6
    Last Post: 03-14-2011, 04:21 AM
  3. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 AM
  4. Run Database Integrity Check or Skip during Upgrade?
    By soxfan in forum Administrators
    Replies: 8
    Last Post: 01-26-2008, 12:37 AM
  5. Replies: 8
    Last Post: 02-27-2007, 04:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •