Results 1 to 8 of 8

Thread: Mysql update after 7.0 install

  1. #1
    Join Date
    Oct 2010
    Posts
    23
    Rep Power
    4

    Default Mysql update after 7.0 install

    From the release notes:
    After you completed the upgrade to 7.0, the following bullet items may need to be addressed.
    • 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 

    ***
    Can I run this while the server is running, or must Zimbra be offline during this update?

  2. #2
    Join Date
    Oct 2009
    Posts
    147
    Rep Power
    5

    Default

    Quote Originally Posted by cpaul_carling View Post
    From the release notes:
    After you completed the upgrade to 7.0, the following bullet items may need to be addressed.
    • 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 

    ***
    Can I run this while the server is running, or must Zimbra be offline during this update?
    I ran mine right after I completed by upgrade. So at that time I dunno but I reboot after upgrades anyway so

  3. #3
    Join Date
    Oct 2010
    Posts
    23
    Rep Power
    4

    Default

    Still not clear if this update can be run while the Zimbra services and running and users are logged on, or if it must be done with the Zimbra services offline.

    Help!!

  4. #4
    Join Date
    Oct 2009
    Posts
    147
    Rep Power
    5

    Default

    Just do it. To be safe, stop the server and then do it.
    So, as zimbra zmcontrol -shutdown
    As root run the mysql thing
    su zimbra and restart zimbra

    You should then post and tell us if it worked.
    Don't be nervous. Go for it

  5. #5
    Join Date
    Oct 2008
    Location
    Portugal, Castelo Branco
    Posts
    63
    Rep Power
    6

    Default

    Hi !

    As far i'm concern, it has to be done with zimbra running:

    Code:
    /opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl 
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
    Mon May  9 10:07:49 2011: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=AooAzsMby7Nc2vXrNUJAsluF8c --database=zimbra --batch --skip-column-names'.
    I'm doing it now with zimbra running

    Cheers,

    Bruno

  6. #6
    Join Date
    Oct 2008
    Posts
    212
    Rep Power
    6

    Default

    Yes if you send a stop command to zmcontrol it will stop MySQL. You need MySQL running to do the database update. I did mine while everything was running and users were retrieving mail.

  7. #7
    Join Date
    Oct 2009
    Posts
    147
    Rep Power
    5

    Default

    What happens as you go from 7 to 710

  8. #8
    Join Date
    Feb 2009
    Location
    Singapore
    Posts
    503
    Rep Power
    7

    Default

    Must I run "zmmailboxdctl stop" before doing the database update? What happen when this service is stopped? What does this service do? Will my users still able to use Zimbra?

    If not, I will have to schedule a maintenance to update the database. Anything serious if I do not update the database???

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. Replies: 2
    Last Post: 12-09-2006, 04:14 AM
  3. Replies: 4
    Last Post: 01-18-2006, 10:58 AM
  4. Replies: 5
    Last Post: 10-14-2005, 02:29 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
  •