Results 1 to 6 of 6

Thread: [SOLVED] Backup Mysql

  1. #1
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Post [SOLVED] Backup Mysql

    Hi all,
    I have executed the following command for the backup of mysql.
    mysqldump -u mysql --all-databases > /opt/zimbra/zimbra.sql.bu
    but as a result only test's database backup is taken.
    Any one who can help me with the backup of rest of the databases?
    I guess "mysqldump -u mysql --all-databases > /opt/zimbra/zimbra.sql.bu"
    should be taking the backup of all the databases present in mysql server ?

    Any IDEAS.
    Regards
    Adeel

  2. #2
    bougui is offline Junior Member
    Join Date
    Jul 2009
    Location
    Near Montreal, Quebec, Canada
    Posts
    7
    Rep Power
    6

    Default

    your only baking up your default mysql database you should probably give the path to the zimbra database.

    What platefome are you on ?

    /opt/zimbra/mysqlbin/mysqldump could maybe do the trick ?

    Bye

  3. #3
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Exclamation

    Well, this is right that the command was taking the backup of the mysql comes with linux rather then zimbra.

    I also have to provide the path where the DB is store, may be database files.

    Do some onw know about the right path I am suppose to give.
    Well, this is right that the command was taking the backup of the mysql comes with linux rather then zimbra.
    Regards
    Adeel

  4. #4
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Exclamation

    Hi all,
    I had tried the following but didn't had any luck.
    mysqldump --u mysql --all-databases -P 7306 --socket /opt/zimbra/db/mysql.sock > /opt/zimbra/zimbra.sql.bu

    regards
    Adeel

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Perhaps if you checked the wiki you would have found your answer Mysql Crash Recovery - Zimbra :: Wiki - Read section 2.

  6. #6
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Default

    It worked,


    Thanks you very much

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 658
    Last Post: 04-04-2014, 09:01 AM
  2. zimbra opesource Backup Script Problem!
    By tashi in forum Administrators
    Replies: 4
    Last Post: 03-30-2009, 11:49 PM
  3. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  4. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  5. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM

Posting Permissions

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