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

[adeelarifbhatti]

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

[uxbod]

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

[adeelarifbhatti]

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

[phoenix]

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.

[adeelarifbhatti]

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

[uxbod]

ZCS System Architecture - Zimbra :: Wiki