View Single Post
  #1 (permalink)  
Old 07-09-2009, 01:00 AM
adeelarifbhatti adeelarifbhatti is offline
Advanced Member
 
Posts: 186
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 01:03 AM..
Reply With Quote