Results 1 to 6 of 6

Thread: backingup and purpose of MYSQL's databases IN ZIMBRA ???

  1. #1
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Exclamation backingup and purpose of MYSQL's databases IN ZIMBRA ???

    Hi all,
    I have the following databases in zimbra's mysql.
    Which one should be backuped ??
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | mboxgroup1 |
    | mboxgroup2 |
    | mboxgroup3 |
    | mboxgroup4 |
    | mboxgroup5 |
    | mboxgroup6 |
    | mboxgroup7 |
    | mysql |
    | test |
    | zimbra |
    +--------------------+
    11 rows in set (0.00 sec).
    I want to backup my sql for the following purpose.
    1- In case of some disaster or lets say deploying the server again, the uses can be created again in ldap.
    2- Data of mail boxes are available as we will take the backup of store on daily bases.
    3- If both the things have been restored (mentioned above), we still need to populate the mysql with some information i.e. the folder 23 in store was belonging to user32@domain.com. isn't?
    As I have many databases in mysql, how would I be knowing that for which purpose these databases are used a part from the info that the uses owned the folder say 32 etc?

    Regards
    Adeel
    Last edited by adeelarifbhatti; 07-09-2009 at 12:03 AM.

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Well you should be backing up /opt/zimbra and not just the MySQL databases.

  3. #3
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Unhappy

    Thanks,
    But in older to understand zimbra in a better way and to make the services available in all kind of situations I really want to understand it.
    I am taking the backup of all the databases but its really not working, following command is used to take the backup.

    mysqldump -u mysql --all-databases > /opt/zimbra/zimbra.sql.bu.
    I can see so much information in the databases about the header and certain more thing in the database, but cannot hit the right stuff.
    Please guide me

    Regards
    Adeel

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

    To take a backup of Zimbra OSS you need to shutdown Zimbra then backup the /opt/zimbra directory structure. Search the forums & wiki for details and alternatives for backing-up the OSS version.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Exclamation

    May be not the header but some information from the header is stored in the mysql.


    This is really great if we can have some deep knowledge about function and recovery of mysql in zimbra.

    Regards
    Adeel

  6. #6
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

Posting Permissions

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