Restore DB or Table via Cron Manager

Hi Everyone,
I'm Using MODX Revolution 2.2.6-pl (traditional)
I have found and configured the Databackup package and that is working great in my test environment.
http://rtfm.modx.com/extras/revo/databackup


In production I only have access to FTP and not the server command line so I'm thinking about how I can restore a table or an entire DB if something runs off the rails.

The obvious way would seem to be create another Cron Manager job / Snipit / php script and pass in the name of the backup.sql file that I want to restore. Set the job to only run once then disable it when not in use.

Not being one to reinvent the wheel I'm wondering if anyone has already solved this problem?

I'm open to suggestions and comments of alternative approaches.

Thanks
David

In the first place, please update your MODX. That version is subject to vulnerabilities. You have subscribed to the security mailing list, haven't you? And the security news feed should be displayed in your Manager's dashboard when you log in.

https://forums.modx.com/thread/92129/critical-login-xss-csrf-revolution-2-2-1-4-and-prior#dis-post-503208
http://modx.us1.list-manage1.com/subscribe?u=08b25a8de68a29fe03a483720&id=332d3ceb26

Hi Sottewll,
Upgrading is a bit scary for me as I didn't originally build the site.
We only have limited support from the people who did. (At great expense)

I agree upgrading is a good idea.

It would make sense that I have a way back if the upgrade turns pear shaped.
I can backup and restore the static files via FTP but not the database.

I should be OK to install the Databackup package on my production server but it isn't much use if I can't restore.

I also want to test the upgrade and restore first in my test environment before I do the production server so I have some confidence that I know what I'm doing.

Thanks for your input
David