Administration/System/Database manager
From Lanius CMS Wiki
Contents |
Database
Lanius CMS offers to users the option of using a flat file database system (such as Gladius DB), so they don't need to use a relational database management system, such as MySQL. This is especially useful if you are using a free hosting account, or any account that does not offer a professional database system. The database used by your Lanius CMS installation contains a number of tables that record information regarding all aspects of the installation. They contain the details of your configuration, modules, subsites, users, drabots, components, and some other aspects not mentioned. As a member of the Administrator or Manager group, you can administrate the database through the System => Database => Backup manager page and even query the database by using System => Database => Query database option of the administration backend.
Download
You can download backup by clicking on Download hyperlink next to the database backup file name.
Alternatively, you can download the file via FTP or SSH by reaching the private/backup directory.
Creating backup
It is important to make regular backups of the database. Unexpected server errors can occur, and all your data can be destroyed. Users would not be recognized, and all other settings unique to your site would be lost. Also, your database may become corrupted in the future, so it is always very wise to have a backup that will allow you to restore the database to previous state. When you make a backup of the database, Lanius CMS generates a file with the extension .sql.php. This is simply a PHP file with SQL instructions which will restore your database after running. This file can be downloaded, if you wish to have multiple copies. To create new backup click on Create button. A new form will load, displaying you with several options. Once you finalise the different options available you should click on the Create button.
After pressing OK button, the backup file
is created and you are returned to an updated System => Database => Backup manager page.
Restoring backup
You can restore the database from the created backup file by selecting checkbox next to the name of your database backup, and clicking on Restore button. A prompt window will be displayed, asking you if to proceed with restoring backup content to your current database.
After pressing OK button, the SQL Results page will be displayed, listing the SQL statements that have been executed. The bottom of the page summarizes the operation. The database is restored if the operation status is reported to be 100% complete.
When you click on Back button you will be returned to System => Database => Backup manager page.
Uploading backup
If you have a backup file which wasn't created in your Lanius CMS installation, you can still use it by clicking on Upload button. For example, if you have a database backup file that you have downloaded from a previous (or other) Lanius CMS installation, you can upload that file to restore the current installation to the previous one. However, please note that only SQL files, or PHP files with SQL statements, should be uploaded.
Click on Browse, in file upload box select
the backup file located on your local computer and press
Open button. Please note that only files with
.sql and .php extensions are
allowed. Once the backup file is attached, you can click on the
Upload button. Once the file is uploaded, and you are
returned to the updated System => Database => Backup manager page.
Deleting backup
If you back up your database regularly, over time, the backup
files will start to accumulate. As the majority of these backup files
will not likely be useful, it is a good practice to delete them. To
delete backup select the checkbox next to the backup you want to
delete and press Delete button. A prompt window
will be displayed, asking if you want to proceed.
Click OK. The backup file is deleted, and
the System => Database => Backup manager
page is updated.
