Results 1 to 3 of 3

Thread: Safe way to copy the Zimbra MySQL database?

  1. #1
    NathanL is offline Loyal Member
    Join Date
    Apr 2009
    Posts
    93
    Rep Power
    5

    Default Safe way to copy the Zimbra MySQL database?

    I'm curious if there's a safe way to grab a copy of the Zimbra MySQL database while zimbra is online. mysql-dump locks the database while its in progress, correct? That seems like a bad thing to do on a live database. What other methods are there?

    Thanks!

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

    Default

    Quote Originally Posted by NathanL View Post
    I'm curious if there's a safe way to grab a copy of the Zimbra MySQL database while zimbra is online. mysql-dump locks the database while its in progress, correct? That seems like a bad thing to do on a live database. What other methods are there?
    To ensure the consistency of your Zimbra server (assuming it's the OS version) then you'll need to stop Zimbra and perform a backup. There are several articles in the wiki and threads in the forums covering backup strategies.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    NathanL is offline Loyal Member
    Join Date
    Apr 2009
    Posts
    93
    Rep Power
    5

    Default

    The goal of the dump is to get me a copy of the database, which i could then use for some fact-finding. Not for use as a backup.

    My reading on mysqldump suggests that the --single-transaction option may get me what i want, without locking the database. Can anyone confirm that?

    Thanks!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Zimbra logwatch.
    By nishith in forum Administrators
    Replies: 5
    Last Post: 06-10-2009, 04:42 PM
  2. Upgrade to ZCS 5.10
    By blozancic in forum Installation
    Replies: 0
    Last Post: 10-21-2008, 08:03 AM
  3. [SOLVED] parts_decode_ext error
    By jsabater in forum Administrators
    Replies: 7
    Last Post: 10-13-2008, 07:24 AM
  4. [SOLVED] Clamav problem ? What's happening ?
    By aNt1X in forum Installation
    Replies: 23
    Last Post: 02-14-2008, 05:43 AM
  5. Cleanup after many upgrades
    By tobru in forum Installation
    Replies: 1
    Last Post: 12-23-2007, 09:21 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
  •