Difference between revisions of "Hot Backup and Restore"
Barrymavin (Talk | contribs) (→Backup and Restore in the Cloud) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
''Under construction'' | ''Under construction'' | ||
− | + | ||
==Backup and Restore during development== | ==Backup and Restore during development== | ||
− | |||
You can perform a Hot Backup and Restore of Apps and Databases while developing in the App Builder. | You can perform a Hot Backup and Restore of Apps and Databases while developing in the App Builder. | ||
There is no need to close the App or Database to perform these operations. | There is no need to close the App or Database to perform these operations. | ||
− | |||
− | |||
<div style="height:80px;margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | <div style="height:80px;margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | ||
Line 15: | Line 12: | ||
<span style="height:6px;"> </span> | <span style="height:6px;"> </span> | ||
</div> | </div> | ||
+ | |||
+ | ===Backup App=== | ||
+ | Select '''Apps''' then '''Backup App...''' from the App Builder MenuBar: | ||
[[{{ns:file}}:backup_app.png|800px|thumb|left|link={{filepath:backup_app.png}}|Backup App]] | [[{{ns:file}}:backup_app.png|800px|thumb|left|link={{filepath:backup_app.png}}|Backup App]] | ||
<br clear=all> | <br clear=all> | ||
+ | Click '''Yes''' to continue when prompted, or '''No''' to cancel. | ||
[[{{ns:file}}:backup_app2.png|left|link={{filepath:backup_app2.png}}|Backup App]] | [[{{ns:file}}:backup_app2.png|left|link={{filepath:backup_app2.png}}|Backup App]] | ||
<br clear=all> | <br clear=all> | ||
+ | Progress information messages will be displayed in the top right corner. | ||
[[{{ns:file}}:backup_app3.png|800px|thumb|left|link={{filepath:backup_app3.png}}|Backup App]] | [[{{ns:file}}:backup_app3.png|800px|thumb|left|link={{filepath:backup_app3.png}}|Backup App]] | ||
<br clear=all> | <br clear=all> | ||
+ | Backups are stored in the '''backups''' sub-directory of '''apps''' in directories named by year -> month -> day -> time -> app name. | ||
[[{{ns:file}}:backup_app4.png|800px|thumb|left|link={{filepath:backup_app4.png}}|Backup App]] | [[{{ns:file}}:backup_app4.png|800px|thumb|left|link={{filepath:backup_app4.png}}|Backup App]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | Use [[#Restore App|Restore App]] to restore an App from a selected backup. |
+ | |||
+ | ===Restore App=== | ||
+ | Select '''Apps''' then '''Restore App...''' from the App Builder MenuBar: | ||
+ | [[{{ns:file}}:restore_app.png|800px|thumb|left|link={{filepath:restore_app.png}}|Restore App]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | A dialog will be displayed allowing you to select the backup for the current App to be restored. The backups are listed by date and time. |
+ | |||
+ | Click on the backup to restore, then click '''OK''' to continue, or '''Cancel''' to cancel. | ||
+ | [[{{ns:file}}:restore_app2.png|800px|thumb|left|link={{filepath:restore_app2.png}}|Restore App]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | Click '''Yes''' to continue when prompted, or '''No''' to cancel. |
+ | [[{{ns:file}}:restore_app3.png|left|link={{filepath:restore_app3.png}}|Restore App]] | ||
<br clear=all> | <br clear=all> | ||
+ | Progress information messages will be displayed in the top right corner. | ||
− | [[{{ns:file}}: | + | ===Backup Database=== |
+ | Select '''Database''' then '''Backup Database...''' from the App Builder MenuBar: | ||
+ | [[{{ns:file}}:backup_database.png|800px|thumb|left|link={{filepath:backup_database.png}}|Backup Database]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | Click '''Yes''' to continue when prompted, or '''No''' to cancel. |
+ | [[{{ns:file}}:backup_database2.png|left|link={{filepath:backup_database2.png}}|Backup Database]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | Progress information messages will be displayed in the top right corner. |
+ | [[{{ns:file}}:backup_database3.png|800px|thumb|left|link={{filepath:backup_database3.png}}|Backup Database]] | ||
<br clear=all> | <br clear=all> | ||
− | [[{{ns:file}}: | + | Backups are stored in the '''backups''' sub-directory of '''data''' in directories named by year -> month -> day -> time -> database name. |
+ | [[{{ns:file}}:backup_database4.png|800px|thumb|left|link={{filepath:backup_database4.png}}|Backup Database]] | ||
<br clear=all> | <br clear=all> | ||
+ | Use [[#Restore Database|Restore Database]] to restore a database from a selected backup. | ||
+ | |||
+ | ===Restore Database=== | ||
+ | Select '''Database''' then '''Restore Database...''' from the App Builder MenuBar: | ||
[[{{ns:file}}:restore_database.png|800px|thumb|left|link={{filepath:restore_database.png}}|Restore Database]] | [[{{ns:file}}:restore_database.png|800px|thumb|left|link={{filepath:restore_database.png}}|Restore Database]] | ||
<br clear=all> | <br clear=all> | ||
+ | A dialog will be displayed allowing you to select the backup for the current database to be restored. The backups are listed by date and time. | ||
+ | |||
+ | Click on the backup to restore, then click '''OK''' to continue, or '''Cancel''' to cancel. | ||
[[{{ns:file}}:restore_database2.png|800px|thumb|left|link={{filepath:restore_database2.png}}|Restore Database]] | [[{{ns:file}}:restore_database2.png|800px|thumb|left|link={{filepath:restore_database2.png}}|Restore Database]] | ||
<br clear=all> | <br clear=all> | ||
+ | Click '''Yes''' to continue when prompted, or '''No''' to cancel. | ||
[[{{ns:file}}:restore_database3.png|left|link={{filepath:restore_database3.png}}|Restore Database]] | [[{{ns:file}}:restore_database3.png|left|link={{filepath:restore_database3.png}}|Restore Database]] | ||
<br clear=all> | <br clear=all> | ||
+ | Progress information messages will be displayed in the top right corner. | ||
==Backup and Restore in the Cloud== | ==Backup and Restore in the Cloud== | ||
Line 100: | Line 126: | ||
unlockresourceall() | unlockresourceall() | ||
</code> | </code> | ||
+ | |||
+ | |||
+ | [[Category:Versions Workspace]] |
Revision as of 09:15, 14 December 2017
Under construction
Contents
Backup and Restore during development
You can perform a Hot Backup and Restore of Apps and Databases while developing in the App Builder.
There is no need to close the App or Database to perform these operations.
The Versions workspace keeps track of all of your modifications to your Apps and scripts and can be used to restore previous versions if you mess something up during development.
Backup App
Select Apps then Backup App... from the App Builder MenuBar:
Click Yes to continue when prompted, or No to cancel.
Progress information messages will be displayed in the top right corner.
Backups are stored in the backups sub-directory of apps in directories named by year -> month -> day -> time -> app name.
Use Restore App to restore an App from a selected backup.
Restore App
Select Apps then Restore App... from the App Builder MenuBar:
A dialog will be displayed allowing you to select the backup for the current App to be restored. The backups are listed by date and time.
Click on the backup to restore, then click OK to continue, or Cancel to cancel.
Click Yes to continue when prompted, or No to cancel.
Progress information messages will be displayed in the top right corner.
Backup Database
Select Database then Backup Database... from the App Builder MenuBar:
Click Yes to continue when prompted, or No to cancel.
Progress information messages will be displayed in the top right corner.
Backups are stored in the backups sub-directory of data in directories named by year -> month -> day -> time -> database name.
Use Restore Database to restore a database from a selected backup.
Restore Database
Select Database then Restore Database... from the App Builder MenuBar:
A dialog will be displayed allowing you to select the backup for the current database to be restored. The backups are listed by date and time.
Click on the backup to restore, then click OK to continue, or Cancel to cancel.
Click Yes to continue when prompted, or No to cancel.
Progress information messages will be displayed in the top right corner.
Backup and Restore in the Cloud
Downtime of SaaS applications in the Cloud is not something your users are going to be happy about. So, with Lianja Cloud Server you can perform a Hot Backup and Restore of your databases while users are running Lianja Apps.
There is no need to shutdown IIS or Apache to perform these operations.
The backup operations can be run at scheduled intervals using cron on linux or task scheduler on Windows.
When the Cloud Server receives a request it uses the lockResource() function internally to get a shared lock on the named resource "LianjaCloudServerRequestLoop".
After it services the request it then continues in the request loop waiting for another request to arrive.
So, all you need to do in your cron job (or windows task scheduler job) is have a small Lianja runtime script or in this example an .rsp file (that can be run using wget) that locks the "LianjaCloudServerRequestLoop" exclusively.
Example
<%@ Language=VFP %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> </head> <body> <% unlockResource("LianjaCloudServerRequestLoop") lockResource("LianjaCloudServerRequestLoop", "exclusive") // Once the exclusive lock has been granted carry out required operations // ... // Then release the lock to unblock other requests unlockResource("LianjaCloudServerRequestLoop") %> </body> </html> // Custom named resource: lockResource("myresource", "exclusive") // Resources can be unlocked individually by name: unlockResource("myresource") // Or all previously locked resources can be unlocked: unlockresourceall()