args are picked up by Drone SSH instead of mysqldump

[manuelmeurer]

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    /
/_______  /__|   \____/|___|  /\___  >         /_______  /_______  /\___|_  /
        \/                  \/     \/                  \/        \/       \/
[...]

[dr5hn]

@manuelmeurer Thanks for reporting. 🎉

Can you please try adding -y instead of --no-tablespaces and check if it works?

[manuelmeurer]

@dr5hn I already solved this by granting the PROCESS privilege to the db user, so I can't test it, sorry.