Backup and Restore

From Lianjapedia
Jump to: navigation, search

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.

Bm-noteicon.png
Pro Tip

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:

Backup App


Click Yes to continue when prompted, or No to cancel.

Backup App


Progress information messages will be displayed in the top right corner.

Backup App


Backups are stored in the backups sub-directory of apps in directories named by year -> month -> day -> time -> app name.

Backup App


Use Restore App to restore an App from a selected backup.

Restore App

Bm-noteicon.png
Pro Tip

If you have not yet saved changes and want to undo them, you can Revert to last saved version of this App.
Just click the button in the Headerbar: Revert to last saved
Note that the App is saved when the Desktop/Web/Tablet/Phone App Viewers are activated.

To restore from an App backup, select Apps then Restore App... from the App Builder MenuBar:

Restore App


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.

Restore App


Click Yes to continue when prompted, or No to cancel.

Restore App


Progress information messages will be displayed in the top right corner.

Backup Database

Select Database then Backup Database... from the App Builder MenuBar:

Backup Database


Click Yes to continue when prompted, or No to cancel.

Backup Database


Progress information messages will be displayed in the top right corner.

Backup Database


Backups are stored in the backups sub-directory of data in directories named by year -> month -> day -> time -> database name.

Backup Database


Use Restore Database to restore a database from a selected backup.

Restore Database

Select Database then Restore Database... from the App Builder MenuBar:

Restore Database


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.

Restore Database


Click Yes to continue when prompted, or No to cancel.

Restore Database


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 unlocks the "LianjaCloudServerRequestLoop" resource 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.

Bm-noteicon.png
Pro Tip

The locking of resources is cluster aware so if you are sharing storage across many load balanced compute instances in the Cloud the resource locking can be used.

Example

<%@ Language=VFP %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</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>