Add database (MySQL) actions

[jygastaud]

As discuss in gitter chatroom-fr, it would be really interesting to add options to interact with, at least, MySQL add-ons.

As a summary, options should mimic the Web UI options.

Proposed functonnalities

• Create new backup
• Restore last backup
• Restore backup with ID
• List available backups
• Download a backup with ID

About commands

I see 2 options for commands.

1. Add that command into clever addon providers Something like clever addon providers backup mysql-addon

2. Create a whole new command Something like clever database backup, clever database restore...

[urcadox]

I was thinking of implementing a backups command now that we have the necessary API for it.

This looks like a good place to talk about it.

First off, I guess we should decide if we want a backups command or a subcommand of the addon command. In much the same way, we should implement a tags (sub)command at some point. Should it be a command or a subcommand of both addon and applications?

I'm inclined towards a backups command given that it could be used for more than just add-ons in the future.

[hsablonniere]

I'd say backups command.

[hsablonniere]

@urcadox I was pinged recently by @jygastaud about this...

• Any news?
• Do we have pointers and help/docs for him about the API?

[abenhamdine]

List available backups Download a backup with ID

It would be useful, to avoid to redump the db while it's already done by Clevercloud..

[urcadox]

There is some grunt work to be made on the API side before this can be done, I should get on this rather soon though. I guess I could work on this CLI command next.

In a word: soon ™