[Discussion] Database Backups: Manaual or Automated Backups Directly From Discord

[PrivateDonut]

I am developing a Database Manager bot for Discord that enables users to oversee their database backups, offering both manual and automated options. I'm keen to gauge the interest of users in such a tool. Designed with user-friendliness in mind and built using Python, the bot is nearing its completion.

This Discord bot will work on any MySQL database, even outside of WoW Emulation.

Image of backup command:

 

[splicho]

Not bad, adds some level of convenience! However, what do you think about the feature, that the bot uploads the file directly to discord so you can download it directly from the chat?

Or add some kind of file hosting api (google drive etc, dropbox etc..) if files are bigger than the allowed file size on discord, and the bot posts the link to the file to download upon uploading.

Aside from that, nice work Donut.

 

[PrivateDonut]

Not bad, adds some level of convenience! However, what do you think about the feature, that the bot uploads the file directly to discord so you can download it directly from the chat?

Or add some kind of file hosting api (google drive etc, dropbox etc..) if files are bigger than the allowed file size on discord, and the bot posts the link to the file to download upon uploading.

Aside from that, nice work Donut.

That is a great idea, I didn't think about using third-party API to allow remote backups. It shouldn't be hard to add the option for users, I just have to look around at some file hosting companies that offer an API.

While uploading backups directly to Discord might seem convenient, I am personally against it, due to potential security risks. But It could be an option for those who might prefer that.

 

[PrivateDonut]

The Database Management bot for Discord, designed for local backups, is now fully operational. A remote backup option will be integrated by tomorrow. This is still a work in progress and is planned to be a free release for anyone interested.

Some pictures:
Manaual Backup Commands:


Automated Backup Commands:


Database to store automated backup options:
This feature enables users to automate backups specific to the individual who initiated the command, ensuring that only they have management rights.


.env file to handle a lot of the configuration


Some more images:






TODO:

1. Add option to remove after X amount of backups
2. Add remove backup option (google cloud, etc)
3. Fix /database_restore (erroring out currently after some chanegs)
4. More ideas to come.

 

[JadaDev]

Great Job bro, it's really amazing to finally have such cool Discord Bot!

You really should consider my suggestion, it'll be really great to have it!

 

[Azayaka]

Looks nice, a lot of research and time went into this one. Great job

 

[PrivateDonut]

Looks nice, a lot of research and time went into this one. Great job

Thank you!


I'll be releasing this soon, it's already done just needs some touch ups then I'll post it on Git Hub and post the link here. I'll provide some basic docs on how to set it up so people can self host it if they would like.

 

[Rogue]

Great contribution, thanks for release!!