This topic is locked

Guide 92 – Database Restore

2/17/2025 2:49:50 PM
PHPRunner Tips and Tricks
fhumanes author

img alt
I think this should be Guide 1 , because then I would have provided all my examples with the possibility of RESTORE from a Database backup and both you and I could enjoy the data set sufficient to see the possibilities of the example. Now, in the current situation, most of the time I don't realize that the data has been destroyed and it costs me more than one "click" to restore the situation.

If you need a Demo environment , I think this alternative is very important to keep it always operational.

Actually, the need was raised by a colleague who wanted to install a development on local PCs and wanted to have the possibility of Backup and Restore, of the security copy, making these actions easier for the user.

Objetive

Provide in a PHPRunner development the possibility of Backup of the Database and Restore of one of the Backups.

DEMO: https://fhumanes.com/videoclub2/

User «admin»/»admin»

img alt

Both menu options are built into PHPRunner's security, so they can be assigned to any user profile. This was done using Views from one of the project's tables. It doesn't matter which table you choose, because nothing is used from those tables except the application context and application security. The screens are created using SNIPPETs and 3-state buttons.

If you are interested in the article, continue reading at this link.