Skip to content

Cannot backup a remote MySQL database #1

Description

@bryanagee

You can specify a host in the config, but only mysqldump uses it. When the incremental backup looks at the binlogs, it only looks at the local ones. Possible fixes include:

  1. mounting the remote binlog directory via sshfs
  2. running the tool on the target, and ssh'ing the compressed, encrypted file to the bu server
  3. using the mysql client to read the binlogs remotely.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions