Forums

Resolved
0 votes
Hello,

My Clearos server 6.3 with Zarafa is running fine for a few days now. (the partitoin part finaly work :) )

So on searching how to make a backup off the mail database I found hints on make a MySQL dump from the Zarafa database.

But here comes the confusing part, there is no Zarafa database in MySQL when I look in phpMyadmin???

When I list the databases from the MySQL CLI it's not there either???

Where stores Zarafa the mail?? Help me please because I want to make a backup.

Regards, Ruud.
In Mail
Wednesday, August 22 2012, 11:59 AM
Share this post:
Responses (4)
  • Accepted Answer

    Tuesday, December 13 2016, 03:15 PM - #Permalink
    Resolved
    0 votes
    @stefanus

    You've dug up a 4 year old thread...perhaps better to start a new one.

    FYI - the Zarafa database uses a sandboxed version of MariaDB (in v7...MySQL in v6), located in /usr/clearos/sandbox/usr/bin/....

    B.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 13 2016, 06:35 AM - #Permalink
    Resolved
    0 votes
    Hi tim,
    I'm sorry i can't view database zarafa in mysql? why this problem?

    mysql_host = 127.0.0.1
    mysql_port = 3308
    mysql_user = zarafa
    mysql_password = m//szgCOAUcgWbvAgd7W0gTShlY=
    mysql_socket =
    mysql_database = zarafa


    But i grep q can view this..
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 22 2012, 12:28 PM - #Permalink
    Resolved
    0 votes
    Hello Tim,

    Thanxxs again for your outstanding help. Pfieuw, this is nice. I gona give the script from James Josehp a try.

    Regards, Ruud.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 22 2012, 12:18 PM - #Permalink
    Resolved
    0 votes
    Its stored in system-mysql, a seperate instance specific for webconfig apps. This operates on port 3308.
    http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,39/func,view/id,41438/limit,10/limitstart,60/#42517

    Find you password and details by running
    grep ^mysql /etc/zarafa/server.cfg


    To perform a databse dump run
    /usr/clearos/sandbox/usr/bin/mysqldump -u zarafa -p --single-transaction zarafa | gzip > /var/tmp/zarafadump.sql.gz


    If you like to use phpMyAdmin, you can configure it to connect to system-mysql see my post here
    http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,39/func,view/id,41438/limit,10/limitstart,60/#42525
    The reply is currently minimized Show
Your Reply