The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Unable to Backup Remote Mysql Directory

Discussion in 'Data Protection' started by Pablo Morales, Oct 2, 2016.

  1. Pablo Morales

    Pablo Morales Member

    Joined:
    Sep 18, 2016
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    Hi there guys ,

    I configured cPanel to use a remote database ( galera cluster ) so far so good, then I configured the backups, and configured it to Per Account and Entire MySQL Directory, the account seems to be working but I get the following error: ( Unable to backup MySQL directory for a remote MySQL server. )

    In the log file ( /usr/local/cpanel/logs/cpbackup ) I can only see:

    2016-10-02 20:02:15 +0100] info [backup] Final state is Backup::PartialFailure (0)
    [2016-10-02 20:02:15 +0100] info [backup] Sent Backup::PartialFailure notification,
    Apart from that I do not see nothing else, no error connecting to, invalid password, permission denied to or
    something like that.

    Can anybody explain to me how's this process works? how do to the system connects to the remote database? is that over ssh? an sql connection? just in case I copy root public keys to the db nodes but same issue, and the profile is validated already, its working, users ID are being added to the remote DB.

    I also have the mysql service enabled on the local server , do not know if that's good or not.

    Thanks
    Regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    It's currently not possible to utilize the "Entire MySQL Directory" backup option when using a remote MySQL server. We implemented a case in cPanel version 58 to address this issue:

    Fixed case CPANEL-5736: Disallow entire MySQL directory backup selection for remote MySQL.

    Could you ensure that "Per Account Only" is selected and let us know if the issue persists?

    Thank you.
     
  3. Pablo Morales

    Pablo Morales Member

    Joined:
    Sep 18, 2016
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    Hi,
    Do you mean that Per Account Only is supported when a remote database is used? nor even Account and Database? I can handle the remote directory if necessary.

    Thank you very much for your time and support
    Regards
     
  4. Pablo Morales

    Pablo Morales Member

    Joined:
    Sep 18, 2016
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    I wanted to say if only Per Account Only option is supported, cannot I chose Account and Database pero user account?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm referring to the following section of the "WHM >> Backup Configuration" option:

    When using a remote MySQL server, the only supported option is:

    Per Account Only

    Thanks!
     
  6. Pablo Morales

    Pablo Morales Member

    Joined:
    Sep 18, 2016
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    Ok, thank you very much, I'll handle the DB backup by my own
    Regards
     
    cPanelMichael likes this.
Loading...

Share This Page