valerianpereira/backup-action

🗄️ Github Action to backup MySQL, MongoDB and PostgreSQL databases

backup-action's Issues

args are picked up by Drone SSH instead of mysqldump

I'm trying to pass args to mysqldump (--no-tablespaces to avoid err: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces) but Drone SSH tries to use them instead.

My action:

- uses: valerianpereira/backup-action@master
  with:
    [...]
    args: --no-tablespaces

Output:

🔑 Loading the ssh key...
Done!! 🍻
🗃️ Backup type: db
DB type: mysql
🏃‍♂️ Running commands over ssh...
Incorrect Usage. flag provided but not defined: -no-tablespaces


________                                         _________ _________ ___ ___
\______ \_______  ____   ____   ____            /   _____//   _____//   |   \
 |    |  \_  __ \/  _ \ /    \_/ __ \   ______  \_____  \ \_____  \/    ~    \
 |    |   \  | \(  <_> )   |  \  ___/  /_____/  /        \/        \    Y    /
/_______  /__|   \____/|___|  /\___  >         /_______  /_______  /\___|_  /
        \/                  \/     \/                  \/        \/       \/
[...]

load pubkey "/github/home/.ssh/deploykey": invalid format

I get the error (warning?) load pubkey "/github/home/.ssh/deploykey": invalid format during syncing.
The sync seems to succeed regardless, though.

Full output:

[...]
==============================================
✅ Successfully executed commands to all host.
==============================================
🔄 Sync the mysql backups... 🗄
load pubkey "/github/home/.ssh/deploykey": invalid format
Warning: Permanently added '207.154.209.XXX' (ECDSA) to the list of known hosts.
receiving incremental file list
mysql-ghost_production.1908211222.sql.gz

              0   0%    0.00kB/s    0:00:00  
        616.55K 100%    1.25MB/s    0:00:00 (xfr#1, to-chk=0/1)

sent 51 bytes  received 603.34K bytes  172.40K bytes/sec
total size is 616.55K  speedup is 1.02
🤔 Whats the location of backups...
/github/workspace/backups
🔍 Show me backups... 😎
total 604K   
-rw-r--r--    1 ***     ***      602.1K Aug 19 12:22 mysql-ghost_production.1908211222.sql.gz

Missing option to make a backup of all databases

Since the Input variable db_name is required it would be convenient to configure the option to make a backup of all databases at the same time. It's cool that you can add multiple databases like this db_name: global,users,staff but it would be cool to do all with one command.