Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A synthetic backup method and apparatus for a MySQL database

A synthetic backup and database technology, which is applied in database models, data redundancy in calculations, data error detection, electrical digital data processing, etc., can solve the problems of long backup time and large space occupation, and achieve convenient management and fast transmission , Improve the efficiency of storage and reading

Inactive Publication Date: 2019-01-04
广州鼎甲计算机科技有限公司
View PDF11 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, it is necessary to provide a synthetic backup method, device, computer equipment and computer-readable storage medium for a MySQL database aiming at the above-mentioned technical problems that the physical backup method of the existing MySQL database takes up a large space and takes a long time for backup

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A synthetic backup method and apparatus for a MySQL database
  • A synthetic backup method and apparatus for a MySQL database
  • A synthetic backup method and apparatus for a MySQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0044] The synthetic backup method of MySQL database provided by the present invention can be applied to such as figure 1shown in the application environment. Wherein, the terminal 110 communicates with the server 120 through the network. The server 120 is used to store backup data and backup records. When the database in the terminal 110 needs to be backed up, if the current database to be backed up is the first backup, the terminal 110 will fully back up the database, and the fully backed up backup data will be stored in In the server 120; if the current database to be backed up is not backed u...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a synthetic backup method, a device, a computer device and a computer-readable storage medium of a MySQL database. The method comprises: if the database to be backed up is thefirst backup, the database is backed up completely; if the database is the second backup, the database is backed up completely; if the current database to be backed up is not the first backup, the incremental data between the current database to be backed up and the last backed up database is obtained, and the incremental data is backed up; the backed up incremental data is synthesized into the last backed up data to generate the current number of backups. The composite backup method of the MySQL database comprises the following steps: the first backup is performed for full backup, and the subsequent backup only needs to synthesize the incremental data into the last backup data, so that the backup time is shortened to the time of backing up the incremental data; the new backup data obtained from each backup is a virtual full backup, and only incremental data is stored between two consecutive virtual full backups, which saves storage space. Effectively improves the efficiency of backups and reduces the storage space used by backups.

Description

technical field [0001] The invention relates to the technical field of database backup, in particular to a synthetic backup method, device, computer equipment and computer-readable storage medium of a MySQL database. Background technique [0002] MySQL database is a relational database management system. Due to its high performance, low cost, and good reliability, MySQL has become one of the most popular open source databases. To prevent data loss caused by hardware failures, software failures, natural disasters, misuse, etc., it is necessary to back up the MySQL database. [0003] Commonly used backup methods for MySQL databases include logical backup, physical backup, and log backup. Physical backup is performed by copying data files. There is no need to query the database, only files are backed up, so it has a faster backup speed. However, the existing physical backup method of MySQL database has the problems of large space occupation and long backup time, and the backu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F11/14G06F16/28
CPCG06F11/1453
Inventor 范华王子骏马立珂王贤达
Owner 广州鼎甲计算机科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com