Results 1 to 6 of 6

Thread: [SOLVED] Backup Mysql

  1. #1
    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
    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
    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
    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
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

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

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

    Default

    It worked,


    Thanks you very much

Similar Threads

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