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.