SYSTEM AND METHOD FOR BACKING UP A DATABASE

Abstract

An exemplary system for backing up a database is disclosed. The system includes at least one remote server (1), and an application server (4) configured between the database and the at least remote server. A related method is also disclosed. The method includes the steps of: receiving parameters; backing up a database and generating a local backup file in an application server; and transferring the local backup file to a remote server and generating a remote backup file in the remote server.

Description

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a schematic diagram of a hardware configuration of a system for backing up a database in accordance with a preferred embodiment;

FIG. 2 is a schematic diagram of main function modules of the application server of the system of FIG. 1; and

FIG. 3 is a flow chart of a preferred method for backing up a database by utilizing the system of FIG. 1.

Claims

1. A system for backing up a database which stores kinds of data, the system comprising at least one remote server and an application server configured between the database and the at least one remote server, the application server comprising: a receiving module configured for receiving parameters, the parameters comprising a first time schedule for backing up the database and generating a local backup file, a second time schedule for transferring the local backup file to the at least one remote server, and login information for logining to the at least one remote server;a backup module configured for backing up the database according to the first time schedule, and generating the local backup file in the application server; and

2. The system according to claim 1, wherein the application server further comprises a determining module configured for detecting whether it is time to backup the database according to the first time schedule, and detecting whether it is time to transfer the local backup file to the at least one remote server according to the second time schedule.

3. The system according to claim 1, wherein the application server further comprises a restoring module configured for recovering the database.

4. The system according to claim 1, wherein the backup module is further configured for generating a backup log file in the application server while generating the local backup file.

5. The system according to claim 1, wherein the transferring module is further configured for generating a transfer log file in the application server while generating the remote backup file.

6. The system according to claim 1, wherein the login information for logining to the at least one remote server comprises an Internet Protocol address of the at least one remote server, a port number of the at least one remote server, and a login name and a login password of the at least one remote server.

7. A computer-based method for backing up a database, the method comprising: receiving parameters, the parameters comprising a first time schedule for backing up the database and generating a local backup file, a second time schedule for transferring the local backup file to a remote server, and login information for logining to the remote server;backing up the database if it is time to backup the database according to the first time schedule, and generating the local backup file in an application server connected with the database; andtransferring the local backup file to the remote server if it is time to transfer the local backup file to the remote server according to the second time schedule and the login information for logining to the remote server, and generating a remote backup file in the remote server.

8. The method according to claim 7, further comprising the step of: restoring the database when data in the database contains abnormities.

9. The method according to claim 7, further comprising the step of: generating a backup log file in the application server while generating the local backup file.

10. The method according to claim 7, further comprising the step of: generating a transfer log file in the application server while generating the remote backup file.

11. The method according to claim 7, wherein the login information for logining to the remote server comprises an Internet Protocol address of the remote server, a port number of the remote server, and a login name and a login password of the remote server.