Database backup method, database restoration method and related devices

Abstract

The invention discloses a database backup method, a database restoration method and related devices and relates to the technical field of computers. A specific embodiment of the method comprises steps of calculating a first table structure check code of a data table of a database, and generating a backup data table of the data table under the condition that the first table structure check code is not found in a data table tuple structure of a stored data table tuple structure set. According to the method, automatic identification of database increment and modification, rapid data export, shortening of backup time, reduction of backup disk space occupation and reduction of artificial configuration of incremental backup can be achieved, database version limitation is avoided, universality is good, checking can be directly conducted in an SQL mode, backup data can still be accessed under the condition that a database server is damaged, and data modification can be customized.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a database backup method, a database restoration method and related devices. Background technique [0002] Relational database backup generally uses a database export tool to export the full amount of each database and table, and then transmits it to the backup server through the network. Another solution is to use database table and field configuration to filter out new data and then export it, and then transmit it to the backup server through the network. [0003] Binlog is a function provided by the database itself that can realize incremental and full backup of the database. Although binlog can meet the needs of most database backups, it still has the following deficiencies: database configuration is required to enable related functions, there are database version restrictions, the processing of different types of databases is quite different, the versatility is not strong...

AI Technical Summary

Problems solved by technology

Although binlog can meet the needs of most database backups, it still has the following deficiencies: database configuration is required to enable related functions, there are database version restrictions, the processing of different types of databases is quite different, the versatility is not strong, backup logs The file itself is a binary file and cannot be viewed directly in the form of SQL (Structured Query Language). The backup log file is located locally on the database server, which will occupy server space. If the database server is damaged, the backup file cannot be accessed. This method usually records all The data modification cannot be customized. Usually, the database modification in the test environment is more about changes in the database table structure and new records, and the real-time performance of the database backup frequency is not high, and it has a certain periodicity, such as once a week. , all types of database change monitoring will increase the size of the database backup file

[0005] The full export speed is slow and will take up a lot of storage space; using the configuration method of database tables and fields, the corresponding data needs to be manually configured, and when the structure of the database table changes, the corresponding configuration needs to be performed again, and the increment based on the configuration The backup lacks a database restoration mechanism, which requires manual restoration and is prone to errors; database backup based on binlog has database version restrictions, poor versatility, and inconvenient viewing. When the database server is damaged, the backup data cannot be accessed, and data modification cannot be customized.

Images