CN107861838A - Method and device of the automated back-up MySQL database from storehouse - Google Patents
Method and device of the automated back-up MySQL database from storehouse Download PDFInfo
- Publication number
- CN107861838A CN107861838A CN201710973703.6A CN201710973703A CN107861838A CN 107861838 A CN107861838 A CN 107861838A CN 201710973703 A CN201710973703 A CN 201710973703A CN 107861838 A CN107861838 A CN 107861838A
- Authority
- CN
- China
- Prior art keywords
- server
- script
- backup
- mysql database
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1464—Management of the backup or restore process for networked environments
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Method and device the invention provides automated back-up MySQL database from storehouse, is related to field of computer technology, wherein, the automated back-up MySQL database includes from the method in storehouse：First, to carrying out environment configurations from server, make identical with the master server environment where MySQL database from server, afterwards, backup script is being disposed from server, so, when receiving backup triggering, run backup script, so as to which the data in MySQL database are backuped to from server, pass through above-mentioned processing procedure, realize the automatic duplicating of data on master server to from the purpose on server, build in advance from server, and at this backup script is run from server to realize the data in MySQL database from the automated back-up on server, compared with existing manual backup method, it is convenient and swift, safely and effectively.
Description
Technical field
The present invention relates to field of computer technology, more particularly to automated back-up MySQL database is from the method and device in storehouse.
Background technology
With the development of science and technology, computer technology is progressively popularized, the management and operation of all trades and professions all by computer come
It is achieved.By the utilization of computer technology, the flow more specification of industry-by-industry, consequently facilitating manager check and
Operation, largely save human cost and material resources consumption.
The particularly appearance of database so that data management is no longer only to store and manage data, and is transformed into user
The mode of required various data managements.Deposited from the simplest form for being stored with various data to mass data can be carried out
The large-scale database system of storage is all widely used in all fields.Obviously, database has become economic management
Important means in journey.
MySQL database is a kind of Relational DBMS of open source code, and its processing speed is fast, reliability
By force, adaptability is good, and therefore, MySQL database is widely used in industry-by-industry.But due to the influence of various factors, example
Such as, the data of management are excessively huge, data storage renewal is very fast etc., and in use, event also occurs in MySQL database
Barrier, or even loss of data can be caused.Therefore, need to back up MySQL database during development and application, that is, pass through
Manual mode is established accordingly from database, and carries out manual backup.It is time-consuming to take but this processing procedure is comparatively laborious
Power.
The content of the invention
In view of this, the purpose of the embodiment of the present invention be the provision of automated back-up MySQL database from the method in storehouse and
Device, by setting from server, and from server Run Script realize automated back-up to MySQL database, from
And improve the efficiency of DB Backup.
In a first aspect, the embodiments of the invention provide automated back-up MySQL database from the method in storehouse, including：
To carrying out environment configurations from server, make identical with the master server environment where MySQL database from server；
Backup script is being disposed from server；
When receiving backup triggering, backup script is run, the data in MySQL database are backuped to from server.
With reference in a first aspect, the embodiments of the invention provide the possible embodiment of the first of first aspect, wherein, from
Dynamic backup MySQL database also includes from the method in storehouse：
In the deployment recovery script from server；
When receiving recovery triggering, restoring running script, to establish sync database from server, wherein, it is synchronous
Database is consistent with MySQL database；
Recover data in sync database.
With reference to the first possible embodiment of first aspect, the embodiments of the invention provide second of first aspect
Possible embodiment, wherein, also include before the deployment recovery script from server：
In the deployment deletion script from server；
When receiving deletion triggering, script is deleted in operation, to delete original database from server.
With reference in a first aspect, the embodiments of the invention provide the possible embodiment of the third of first aspect, wherein, from
Dynamic backup MySQL database also includes from the method in storehouse：
When receiving backup triggering, run in advance in the backed up in synchronization script disposed from server；
Data in MySQL database are backuped to during the server, generate backed up in synchronization information in real time.
With reference to the first possible embodiment of first aspect, the embodiments of the invention provide the 4th of first aspect kind
Possible embodiment, wherein, automated back-up MySQL database also includes from the method in storehouse：
When receiving recovery triggering, operation is in advance in the synchronous recovery script disposed from server；
During recovering data in sync database, generation in real time is synchronous to recover information；
Recover information generation mail according to synchronous, and mail is sent to master server.
Second aspect, the device the embodiments of the invention provide automated back-up MySQL database from storehouse, including：
Environment configurations module, for carrying out environment configurations from server, making where server and MySQL database
Master server environment is identical；
Backup script deployment module, for disposing backup script from server；
Backup module, for when receiving backup triggering, backup script being run, by the data backup in MySQL database
To from server.
With reference to second aspect, the embodiments of the invention provide the possible embodiment of the first of second aspect, wherein, from
Dynamic backup MySQL database also includes from the device in storehouse：
Recover script deployment module, in the deployment recovery script from server；
Sync database establishes module, for when receive recover triggering when, restoring running script, to be built from server
Vertical sync database, wherein, sync database is consistent with MySQL database；
Recovery module, for recovering data in sync database.
With reference to the first possible embodiment of second aspect, the embodiments of the invention provide second of second aspect
Possible embodiment, wherein, automated back-up MySQL database also includes from the device in storehouse：
Script deployment module is deleted, in the deployment deletion script from server；
Removing module, for when receiving deletion triggering, script to be deleted in operation, to delete original data from server
Storehouse.
With reference to second aspect, the embodiments of the invention provide the possible embodiment of the third of second aspect, wherein, from
Dynamic backup MySQL database also includes from the device in storehouse：
Backed up in synchronization script deployment module, for when receiving backup triggering, operation to be disposed from server in advance
Backed up in synchronization script；
Backed up in synchronization module, backuped to for the data in MySQL database during the server, generation is same in real time
Walk backup information.
With reference to the first possible embodiment of second aspect, the embodiments of the invention provide the 4th of second aspect kind
Possible embodiment, wherein, automated back-up MySQL database also includes from the device in storehouse：
Recover script deployment module, for when receiving recovery triggering, running in advance in the synchronization disposed from server
Recover script；
Synchronous recovery module, during recovering data in sync database, generation in real time is synchronous to recover information；
Mail sending module, for recovering information generation mail according to synchronous, and mail is sent to master server.
Automated back-up MySQL database provided in an embodiment of the present invention from the method and device in storehouse, wherein, the automated back-up
MySQL database includes from the method in storehouse：It is that the purpose for carrying out environment configurations is to make to carrying out environment configurations from server first
It is identical with the master server environment where MySQL database from server, backup script is being disposed from server afterwards, so
When receiving backup triggering, above-mentioned backup script is run, so as to which the data in MySQL database are backuped to from service
Device, by above-mentioned processing procedure, the automated back-up to the data in master server MySQL database is realized, with existing hand
Dynamic backup mode is compared, convenient and swift, time saving and energy saving.
Other features and advantages of the present invention will illustrate in the following description, also, partly become from specification
Obtain it is clear that or being understood by implementing the present invention.The purpose of the present invention and other advantages are in specification, claims
And specifically noted structure is realized and obtained in accompanying drawing.
To enable the above objects, features and advantages of the present invention to become apparent, preferred embodiment cited below particularly, and coordinate
Appended accompanying drawing, is described in detail below.
Brief description of the drawings
, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical scheme of the prior art
The required accompanying drawing used is briefly described in embodiment or description of the prior art, it should be apparent that, in describing below
Accompanying drawing is some embodiments of the present invention, for those of ordinary skill in the art, before creative work is not paid
Put, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 shows the flow chart of automated back-up MySQL database that the embodiment of the present invention provided from the method in storehouse；
Fig. 2 shows the connection figure of automated back-up MySQL database that the embodiment of the present invention provided from the device in storehouse；
Fig. 3 shows the structural framing of automated back-up MySQL database that the embodiment of the present invention provided from the device in storehouse
Figure；
Fig. 4 shows that the automated back-up MySQL database that the embodiment of the present invention is provided connects from the structure of the device in storehouse
Figure.
Icon：1- environment configurations modules；2- backup script deployment modules；3- backup modules；4- recovers script deployment module；
5- sync databases establish module；6- recovery modules；7- synchronously recovers script deployment module；8- synchronization recovery modules；9- mails
Sending module.
Embodiment
Below in conjunction with accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Ground describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.Generally exist
The component of the embodiment of the present invention described and illustrated in accompanying drawing can be configured to arrange and design with a variety of herein.Cause
This, the detailed description of the embodiments of the invention to providing in the accompanying drawings is not intended to limit claimed invention below
Scope, but it is merely representative of the selected embodiment of the present invention.Based on embodiments of the invention, those skilled in the art are not doing
The every other embodiment obtained on the premise of going out creative work, belongs to the scope of protection of the invention.
Computer application is progressively popularized at present, and many numerous and diverse work become light because of the application of computer technology
Pine.The appearance of particularly database makes data management no longer be only to store and manage data, and is transformed into required for user
The mode of various data managements, database have become the important means during economic management.MySQL database is that one kind is opened
The Relational DBMS of source code is put, its processing speed is fast, highly reliable, adaptability is good, therefore, MySQL data
Storehouse is widely used in industry-by-industry.But due to the influence of various factors, MySQL database can also go out in use
Existing failure.Therefore, need to back up MySQL database during development and application, existing method is manually
Establish accordingly from database, and carry out manual backup.But this processing procedure is comparatively laborious, wastes time and energy.
Based on this, the method and device the embodiments of the invention provide automated back-up MySQL database from storehouse, below by
Embodiment is described.
Embodiment 1
Referring to Fig. 1, the automated back-up MySQL database that the present embodiment proposes specifically includes following steps from the method in storehouse：
Step S101：To carrying out environment configurations from server, make from the master server where server and MySQL database
Environment is identical.
Step S102：Backup script is being disposed from server.
Step S103：When receive backup triggering when, run backup script, by the data in MySQL database backup to from
Server.
Above-mentioned each step is described in detail below, in step S101, to from server (generally, from server
Also referred to as from storehouse) environment configurations are carried out, it is identical with the environment of master server from server in order to ensure, can so subtracts as far as possible
The influence that a small number of differences according to because of local environment in access procedure are brought, so as to not only facilitate the number on master server
According to extraction, it helps in the storage from the data on server, also, need exist for illustrating, MySQL data
Storehouse is provided on master server, and the form of MySQL database can flexibly be set according to usage scenario.
In step s 102, backup script is being disposed from server, is needing exist for illustrating, backup script is
For the script of Backup Data, because script is to use a kind of specific descriptive language, according to certain form write can
Perform file.
In step s 103, it is necessary first to illustrate, backup triggering is inputted by the external world, and the form for backing up triggering is
Directly input order, external action control or the one kind being wirelessly transferred in order.When receiving backup triggering, the front portion of operation
The backup script of administration, the data in MySQL database are backuped to from server by the execution of backup script, so as to automatic
Complete the backup of data.
In addition, also include from the method in storehouse in automated back-up MySQL database：
(1) in the deployment recovery script from server, need exist for illustrating, it is in actual use, extensive
Multiple script and above-mentioned backup script can be all arranged under same engineering, and are described with identical language, with to greatest extent
Upper saving memory consumption, reduce human cost.After the backup of data is completed, it is also necessary to recover data again, with main service
Using the data after recovery when device breaks down, and then the operation of the lasting stability of master server is ensured, therefore, it is necessary to existed in advance
Deployment recovers script from server.
(2) when receiving recovery triggering, need exist for illustrating, the form and above-mentioned backup for recovering triggering trigger
It is similar, and by running the recovery script from server, to establish sync database, here, sync database from server
It is consistent with MySQL database, unanimously mean in the table structure one from the sync database on server and MySQL database
Cause, so that data are completely recovered.
(3) recover data in sync database, will have backed up and insert above-mentioned synchronization from the data on server
In database, the recovery of data is completed in sync database.
In addition, also include before the deployment recovery script from server：
(1) in the deployment deletion script from server, need exist for illustrating, in actual use, delete
Except script and above-mentioned backup script can be all arranged under same engineering, and described with identical language, with to greatest extent
Upper saving memory consumption, reduce human cost.
(2) after, when receiving deletion triggering, above-mentioned deletion script is run, to delete original data from server
Storehouse, due to, the database run from server is all run according to previous derived Backup Data, therefore, in order to
The validity of the data of current backup is verified, it is necessary to be updated to database, that is, establishes above-mentioned sync database.In order to ensure
Database can be effectively updated, and first script be deleted being disposed from server, so as to ensure that database can be carried out effectively
Renewal.
In addition, the backup progress for the above-mentioned data of effective monitoring from master server to backup server, automated back-up
MySQL database also includes from the method in storehouse：
(1) when receiving backup triggering, operation in advance in the backed up in synchronization script disposed from server, need exist for into
Row explanation, in actual use, backed up in synchronization script and above-mentioned backup script can be all arranged under same engineering,
And described with identical language, to save memory consumption on to greatest extent, reduce human cost.
(2) data in MySQL database are backuped to during the server, generate backed up in synchronization information in real time, are led to
The real-time generation of backed up in synchronization information is crossed, for example, by mysqldump backup master server data, and it is same to record master server
Information is walked, has ensured the validity of the data of backup.
In addition, automated back-up MySQL database also includes from the method in storehouse：
(1) when receive recover triggering when, operation in advance disposed from server it is synchronous recover script, need exist for into
Row explanation, in actual use, the synchronous script and above-mentioned backup script of recovering can be all arranged under same engineering,
And described with identical language, to save memory consumption on to greatest extent, reduce human cost.
(2) during recovering data in sync database, generation in real time is synchronous to recover information, that is, recovers what is newly backed up
Data, and foundation and primary server database master-slave synchronisation, and then ensure the integrality of data recovery.
(3) recover information generation mail according to synchronous, consequently facilitating user is checked, and mail is sent to main service
Device, so that master server can check the recovery progress of data according to mail.Need exist for illustrating, above-mentioned mail
Form, transmission form etc. according to circumstances can flexibly be set.
In summary, the automated back-up MySQL database that the present embodiment provides includes from the method in storehouse：Needed before this to from
Server carries out environment configurations, identical with the master server environment where MySQL database from server so as to make, afterwards
Backup script is being disposed from server, will so as to which when receiving backup triggering, backup script can be run from server
Data in MySQL database are backuped to from server, realize the automated back-up of data, also, above-mentioned backup method can also
Synchronizing information etc. is marked, user can be made to view the progress of data backup in time, it is convenient and swift, it is easy to apply.
Embodiment 2
Referring to Fig. 2, Fig. 3 and Fig. 4, present embodiments provide automated back-up MySQL database includes from the device in storehouse：Successively
Connected environment configurations module 1, backup script deployment module 2 and backup module 3, in use, environment configurations module 1 be used for from
Server carries out environment configurations, makes, backup script deployment identical with the master server environment where MySQL database from server
Module 2 is used to dispose backup script from server, and backup module 3 is used to, when receiving backup triggering, run backup script,
Data in MySQL database are backuped to from server.
Automated back-up MySQL database also includes from the device in storehouse：Recover script deployment module 4 to be used for from server
Deployment recovers script, sync database establish module 5 be used for when receive recover triggering when, restoring running script, with from service
Sync database is established on device, wherein, sync database is consistent with MySQL database, and recovery module 6 is used in sync database
Middle recovery data.
Automated back-up MySQL database also includes from the device in storehouse：Script deployment module is deleted to be used for from server
Script is deleted in deployment, and removing module is used for when receiving deletion triggering, and script is deleted in operation, original from server to delete
Database.
Automated back-up MySQL database also includes from the device in storehouse：Backed up in synchronization script deployment module 2 is used for standby when receiving
During part triggering, operation is used for MySQL database in the backed up in synchronization script disposed from server, backed up in synchronization module 3 in advance
In data backup to during the server, generate backed up in synchronization information in real time.
Automated back-up MySQL database also includes from the device in storehouse：Synchronous script deployment module 7 of recovering is for extensive when receiving
When triggering again, operation is used in sync database in the synchronous recovery script disposed from server, synchronous recovery module 8 in advance
During middle recovery data, generation in real time is synchronous to recover information, and mail sending module 9 is used to recover information generation according to synchronous
Mail, and mail is sent to master server.
In summary, the automated back-up MySQL database that the present embodiment provides includes from the device in storehouse：The ring being sequentially connected
Border configuration module 1, backup script deployment module 2 and backup module 3, in use, environment configurations module 1 is used for entering from server
Row environment configurations, make identical with the master server environment where MySQL database from server, and backup script deployment module 2 is used
In disposing backup script from server, backup module 3 is used to, when receiving backup triggering, backup script is run, by MySQL
Data in database are backuped to from server, by the setting of above-mentioned modules, can be effectively improved in MySQL database
The backup efficiency of data, it is convenient and swift.
The automated back-up MySQL database that the embodiment of the present invention is provided is produced from the computer program of the method and device in storehouse
Product, including the computer-readable recording medium of program code is stored, the instruction that described program code includes can be used for before performing
Method described in the embodiment of the method for face, specific implementation can be found in embodiment of the method, will not be repeated here.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description
With the specific work process of device, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In addition, in the description of the embodiment of the present invention, unless otherwise clearly defined and limited, term " installation ", " phase
Even ", " connection " should be interpreted broadly, for example, it may be being fixedly connected or being detachably connected, or be integrally connected；Can
To be mechanical connection or electrical connection；Can be joined directly together, can also be indirectly connected by intermediary, Ke Yishi
The connection of two element internals.For the ordinary skill in the art, with concrete condition above-mentioned term can be understood at this
Concrete meaning in invention.
If the function is realized in the form of SFU software functional unit and is used as independent production marketing or in use, can be with
It is stored in a computer read/write memory medium.Based on such understanding, technical scheme is substantially in other words
The part to be contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter
Calculation machine software product is stored in a storage medium, including some instructions are causing a computer equipment (can be
People's computer, server, or network equipment etc.) perform all or part of step of each embodiment methods described of the present invention.
And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
Finally it should be noted that：Embodiment described above, it is only the embodiment of the present invention, to illustrate the present invention
Technical scheme, rather than its limitations, protection scope of the present invention is not limited thereto, although with reference to the foregoing embodiments to this hair
It is bright to be described in detail, it will be understood by those within the art that：Any one skilled in the art
The invention discloses technical scope in, it can still modify to the technical scheme described in previous embodiment or can be light
Change is readily conceivable that, or equivalent substitution is carried out to which part technical characteristic；And these modifications, change or replacement, do not make
The essence of appropriate technical solution departs from the spirit and scope of technical scheme of the embodiment of the present invention, should all cover the protection in the present invention
Within the scope of.Therefore, protection scope of the present invention described should be defined by scope of the claims.
Claims (10)
1. automated back-up MySQL database is from the method in storehouse, it is characterised in that including：
To carrying out environment configurations from server, make described identical with the master server environment where MySQL database from server；
Backup script is disposed from server described；
When receiving backup triggering, the backup script is run, the data in the MySQL database are backuped to described from clothes
Business device.
2. automated back-up MySQL database according to claim 1 is from the method in storehouse, it is characterised in that methods described is also
Including：
Recover script in the deployment from server；
When receiving recovery triggering, the recovery script is run, to establish sync database from server described, wherein,
The sync database is consistent with the MySQL database；
Recover the data in the sync database.
3. automated back-up MySQL database according to claim 2 is from the method in storehouse, it is characterised in that described described
Deployment recovers also to include before script from server：
Script is deleted in the deployment from server；
When receiving deletion triggering, the deletion script is run, to delete the database original from server.
4. automated back-up MySQL database according to claim 1 is from the method in storehouse, it is characterised in that methods described is also
Including：
When receiving backup triggering, run in advance in the backed up in synchronization script disposed from server；
Data in the MySQL database backup to described during server, real-time generation backed up in synchronization information.
5. automated back-up MySQL database according to claim 2 is from the method in storehouse, it is characterised in that methods described is also
Including：
When receiving recovery triggering, operation is in advance in the synchronous recovery script disposed from server；
During recovering the data in the sync database, generation in real time is synchronous to recover information；
Mail is generated according to the synchronous information of recovering, and the mail is sent to the master server.
6. automated back-up MySQL database is from the device in storehouse, it is characterised in that including：
Environment configurations module, for carrying out environment configurations from server, making described where server and MySQL database
Master server environment is identical；
Backup script deployment module, for disposing backup script from server described；
Backup module, for when receiving backup triggering, the backup script being run, by the data in the MySQL database
Backup to described from server.
7. automated back-up MySQL database according to claim 6 is from the device in storehouse, it is characterised in that also includes：
Recover script deployment module, for recovering script in the deployment from server；
Sync database establishes module, for when receive recover triggering when, run the recovery script, with described from server
On establish sync database, wherein, the sync database is consistent with the MySQL database；
Recovery module, for recovering the data in the sync database.
8. automated back-up MySQL database according to claim 7 is from the device in storehouse, it is characterised in that also includes：
Script deployment module is deleted, for deleting script in the deployment from server；
Removing module, for when receive delete triggering when, run the deletion script, with delete it is described from server it is original
Database.
9. automated back-up MySQL database according to claim 6 is from the device in storehouse, it is characterised in that also includes：
Backed up in synchronization script deployment module, for when receiving backup triggering, operation to be disposed described from server in advance
Backed up in synchronization script；
Backed up in synchronization module, described during server, life in real time is backuped to for the data in the MySQL database
Into backed up in synchronization information.
10. automated back-up MySQL database according to claim 7 is from the device in storehouse, it is characterised in that also includes：
Recover script deployment module, for when receiving recovery triggering, running in advance in the synchronization disposed from server
Recover script；
Synchronous recovery module, during recovering the data in the sync database, generation in real time is synchronous to recover
Information；
Mail sending module, for generating mail according to the synchronous information of recovering, and the mail is sent to the main clothes
Business device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710973703.6A CN107861838A (en) | 2017-10-18 | 2017-10-18 | Method and device of the automated back-up MySQL database from storehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710973703.6A CN107861838A (en) | 2017-10-18 | 2017-10-18 | Method and device of the automated back-up MySQL database from storehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107861838A true CN107861838A (en) | 2018-03-30 |
Family
ID=61696270
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710973703.6A Pending CN107861838A (en) | 2017-10-18 | 2017-10-18 | Method and device of the automated back-up MySQL database from storehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107861838A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471848A (en) * | 2018-09-17 | 2019-03-15 | 沈文策 | A kind of database migration method and device |
| CN110032554A (en) * | 2019-04-10 | 2019-07-19 | 北京字节跳动网络技术有限公司 | Management method, device, storage medium and the electronic equipment of data warehouse table |
| CN111209139A (en) * | 2019-12-29 | 2020-05-29 | 航天信息股份有限公司 | Disaster recovery method and device based on version control management system |
| CN112035435A (en) * | 2020-08-26 | 2020-12-04 | 浪潮云信息技术股份公司 | MySQL master-slave cluster installation deployment method and cluster system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN102880531A (en) * | 2012-09-27 | 2013-01-16 | 新浪网技术(中国)有限公司 | Database backup system and backup method and slave database server of database backup system |
| US8874519B1 (en) * | 2007-12-18 | 2014-10-28 | Symantec Corporation | Method and apparatus for restoring a table in a database |
| CN106383755A (en) * | 2016-09-23 | 2017-02-08 | 北京奇虎科技有限公司 | Method, apparatus and system for recovering slave database from master-slave database system |
-
2017
- 2017-10-18 CN CN201710973703.6A patent/CN107861838A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8874519B1 (en) * | 2007-12-18 | 2014-10-28 | Symantec Corporation | Method and apparatus for restoring a table in a database |
| CN102779191A (en) * | 2012-07-03 | 2012-11-14 | 互动在线（北京）科技有限公司 | Achievement system and achievement method for my structured query language (My SQL) database smooth upgrading |
| CN102880531A (en) * | 2012-09-27 | 2013-01-16 | 新浪网技术(中国)有限公司 | Database backup system and backup method and slave database server of database backup system |
| CN106383755A (en) * | 2016-09-23 | 2017-02-08 | 北京奇虎科技有限公司 | Method, apparatus and system for recovering slave database from master-slave database system |
Non-Patent Citations (3)
| Title |
|---|
| 秋水逸冰: "一键备份脚本backup.sh", 《WEB.ARCHIVE.ORG/WEB/20170704100911/HTTPS://TEDDYSUN.COM/469.HTML/COMMENT-PAGE-1》 * |
| 让酒桶飞: "Linux下定时自动备份远程主机mysql数据库并拷贝到其他主机", 《HTTPS://BLOG.CSDN.NET/WYHAPPY612/ARTICLE/DETAILS/72963448》 * |
| 量变决定质变: "MySQL数据库还原", 《HTTPS://BLOG.CSDN.NET/NANGEALI/ARTICLE/DETAILS/76408616》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471848A (en) * | 2018-09-17 | 2019-03-15 | 沈文策 | A kind of database migration method and device |
| CN110032554A (en) * | 2019-04-10 | 2019-07-19 | 北京字节跳动网络技术有限公司 | Management method, device, storage medium and the electronic equipment of data warehouse table |
| CN111209139A (en) * | 2019-12-29 | 2020-05-29 | 航天信息股份有限公司 | Disaster recovery method and device based on version control management system |
| CN112035435A (en) * | 2020-08-26 | 2020-12-04 | 浪潮云信息技术股份公司 | MySQL master-slave cluster installation deployment method and cluster system |
| CN112035435B (en) * | 2020-08-26 | 2024-04-30 | 浪潮云信息技术股份公司 | MySQL master-slave cluster installation and deployment method and cluster system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107861838A (en) | Method and device of the automated back-up MySQL database from storehouse | |
| CN102981931B (en) | Backup method and device for virtual machine | |
| CN103164295B (en) | Enterprise information technology (IT) business virtualization disaster recovery method based on zettabyte file system (ZFS) and kernel-based virtual machine (KVM) kernel virtual underlying system | |
| CN105843707B (en) | Database quick recovery method and equipment | |
| CN103677973A (en) | Distributed multi-task scheduling management system | |
| CN102360410B (en) | User operation discovery method of file system and synchronous system utilizing the same | |
| CN103970585A (en) | Method and device for creating virtual machine | |
| CN109189860A (en) | A kind of active and standby increment synchronization method of MySQL based on Kubernetes system | |
| CN112199157B (en) | Cloud environment management method | |
| CN106790713B (en) | Across data center virtual machine migration method under cloud computing environment | |
| CN104252500A (en) | Method and device for carrying out fault repairing on database management platform | |
| CN101894137A (en) | Method and device for restoring data in embedded database | |
| CN105630571A (en) | Virtual machine creating method and device | |
| CN107122267A (en) | A kind of Windows operating system carry restoration methods | |
| CN103914307A (en) | Interactive-interface fast implementation method based on reusable library | |
| CN104461773A (en) | Backup deduplication method of virtual machine | |
| CN104765651A (en) | Data processing method and device | |
| CN112631831A (en) | Bare computer recovery method and system of service system | |
| CN104820625A (en) | A data record, backup, and recovery method oriented to an information management system | |
| CN102053855B (en) | Software generation system and method | |
| CN112367186B (en) | Fault protection method and device based on 0penStack bare computer | |
| CN104142838A (en) | Method and equipment for starting up mobile communication terminal | |
| CN103176866A (en) | File permission back-up method applied in new technology file system (NTFS) | |
| CN101022633B (en) | Allocation data recovering method, system and device | |
| CN104407932A (en) | Data backup method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180330 |
|
| RJ01 | Rejection of invention patent application after publication |