|
For the prevention of the data loss from the database of the site that can become irreversible, there is a need to make a backup (archiving) regularly. As soon as the articles are published in MOS, they are written at the common DB, which should be archived. Even if the company – provider says that there is a backup in the list of its services, it would be also useful to make a copy of the data base yourself in order not to have problems.
For making a backup click System> database > backup in the menu panel. MOS is equipped with rather good backup manager, the usage of which simplifies the procedure of backup creation which can be made with a help of a few clicks of the mouse.
For making a backup procedure, it is needed to answer some questions of the system:
Location of the file with DB archive
a) Display Results on the Screen – simple text file is created, which opens in the new window of the browser. It can be saved as a text file wherever you want.
b) Download the file of an archive to my local computer - the file copies at the hard disc (recommended variant of actions).
c) Store the file in the backup directory on the server – archive file is written in the folder on the server. Note: this option is useful in case of the problem with DB integrity, but it can not restore data in case, the server is broken.
Saved data type
a) Data Only – data backup from MOS DB
b) DB Structure Only – back up of the structure data DB MOS is done. Such kind of backup can not restore capacity to work in case of data loss.
c) Data and Structure – the backup of the structure and data DB MOS is done(recommended variant of actions).
Saved file format
a) format Zip As a Zip file –cope of the DB SQL is placed to the archive of XIP format (recommended variant of actions)
b) GZip As a GZip file format – БД SQL copy is to be placed to the archive of tar.gz format. Some servers can hardly understand such an archive. But this archive format is native for the hosting on UNIX- platforms.
c) SQL file – the uncompressed version of text file formatted with the help of SQL is saved (the size of such a file can be bigger in comparison with the archive file).
d) formatted HTML document – the file is formatted with the help of HTML. For more convenient perception some informative blocks are placed into the cells of the table. The size is comparable with SQL-format (the biggest one)
The choice of the separate DB tables for backup.
Sometimes it is not obligatory to make backup of the whole DB MOS, as only separate tables are refreshed usually. The tables of the news and guest book sections are frequently renewed. In such a way the administrator can rule the structure of the saved data in an effort to decrease the size of the archives, saving the DB tables connected with definite theme of the content, module or component.
Note: as it is accessible to choose the tables from the whole list of existing ones, we recommend you to include all the MOS tables in any of the selective backups for more reliable saving of the kernel MOS structure.
For making an operation of selective backup click on the icon Backup the Selected Tables. Then point where the system should save the archive copy and click save. Many users prefer to make several archive versions with different date of creation in the same folder. Use folders on different logic discs or copy the archives to the exchangeable folders.
Restore
Sometimes there can be loss of data or MOS database damage on the server. In this case we can use Restore of the data from the earlier created archive DB MOS function. For maintenance of this function it is recommended to make backup not less than once a week.
For the restore DB function realization form an archive choose in admin menu System > Database > Restore and choose one of the variants of actions.
Variant 1: Reserved copies of DB MOS are located on the web-server. In this case their list will be reflected. Just put a mark opposite the DB copy you want and click the button Perform the Restore. If you have succeeded the system will show you the note.
Variant2: reserved copies are located on the distant folder .Press the button Browse, choose the archive file you need on the disc and click the button Open. Then the button Perform the Restore. If you have succeeded the system will show you the note. |
