Unlock instant, AI-driven research and patent intelligence for your innovation.

A method of backing up a mysql database

A database and backup technology, which is applied to the redundancy in the operation for data error detection, electrical digital data processing, special data processing applications, etc. It can solve problems such as intentional data loss without interest, and achieve reliable design principles and highlight the essence. Sexual characteristics, simple structure effect

Inactive Publication Date: 2018-12-07
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] However, in the prior art, the recovery backup technology for the Mysql database is likely to cause the loss of intentional and interest-free data.

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 method of backing up a mysql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0074] The present invention will be described in detail below with reference to the accompanying drawings and specific embodiments. The following embodiments are explanations of the present invention, but the present invention is not limited to the following embodiments.

[0075] Such as figure 1 As shown, the present embodiment provides a method for mysql database backup, which includes the following steps:

[0076] S1: Enable the master logbin function of the mysql database; specifically include the following steps:

[0077] S11: To enable the master logbin function, it needs to be set under my.ini→[mysqld]:

[0078] Server_id=1

[0079] Log_bin=mysql-bin

[0080] Sync_logbin=1

[0081] Among them, the Server_id is because the main and standby database clusters need to be set up, and different values ​​need to be specified on the standby database. The Log_bin item is the configuration item that indicates to enable the logbin function, and the sync_logbin indicates that...

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 method for backing up a mysql database, which is characterized in that the method comprises the following steps: S1, starting the master logbin function of the mysql database; S2, configuring a slave library; S3, backing up the database; S4, accumulating historical data. Provided is a way to back up a mysql database, which can rebuild a database at any time, and can accumulate all the historical data. This backup method can save the precious data generated in the test process to the maximum extent, avoid all intentional and interest-free data loss, and provide data support for subsequent analysis and audit.

Description

technical field [0001] The invention belongs to the technical field of database design, and in particular relates to a backup method for a mysql database. Background technique [0002] MySQL is a relational database management system, developed by the Swedish company MySQL AB, and currently belongs to Oracle's products. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (Relational Database Management System, relational database management system) application software. [0003] MySQL is a relational database management system. Relational databases store data in different tables instead of putting all the data in one big warehouse, which increases speed and improves flexibility. [0004] The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual authorization policy, which is divided into community edition and commercial editi...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1471
Inventor 郑树锐胥志泉
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD