So at present I'm backing up my code and media using the bin/magento setup:backup method, but experience an error when restoring the database "Multiple queries can't be executed. Run a single query and try again." Still can't find a solution to this.
But my question is, what method do you all use for your backups/rollbacks ??
As it's such a crucial part of any Magento setup, I'm wondering what the most reliable solution would be.
I'm sure this would help others too.
Are the methods dependent on the Magento Version, Hosting, etc...?