Openerp data backup and recovery, openerp backup and recovery

Source: Internet
Author: User

Openerp data backup and recovery, openerp backup and recovery
Back up the entire database:
Use the backup file to restore the database:
Notes:

  • It is best to write a script to automatically back up data
  • If you do not stop openerp When deleting a database, a prompt is displayed, indicating that the database is in use and cannot be deleted.
  • When data is restored, If you import the data directly without clearing the old data, an error is prompted and cannot be imported.

What architecture is openerp?

MVC Architecture (three-tier architecture Model-View-Controller) is a software architecture Model in software engineering ". A complex computer application will display a large amount of data to users, and people want to separate the data (model) from the interface (view. Changing the user interface does not affect data management. data can be reorganized without changing the user interface. The MVC mode (three-tier architecture) decouples Data Reading and business logic by introducing controllers, while solving the problem of data presentation and user interaction.

Principles of database backup and recovery

Generally, a file-type database is actually one or more files. The so-called backup takes these files into account on other media, and there may be a packaging process, or the process of burning to a DVD. This is the best way to back up and restore a file-type database, with the best efficiency and the simplest operation.

Some large databases manage their own buckets, such as partitions or disks, which are not recognized by the operating system. Such databases can also use tools such as GHOST to back up disks.

Many people may say that backup databases convert databases into SQL or text files. In fact, this is another concept called data migration, which aims to port the database data to other database management systems. Data migration is not suitable for routine database backup. Generally, key databases do not normally perform data migration. Generally, the database system provides dedicated data migration tools. Of course, these tools may be a series of SQL statements that can be compiled by yourself.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.