The following is a simple example of how to back up and restore each Database. For more details about the parameters and configurations, see related information. 1. mysql: parameter description: $ user $ password $ targethost $ port $ charset $ dbname $ table $ filename username and password ip address (this document only provides the simplest usage of backing up and recovering databases, for more detailed parameters and configurations, refer to the relevant information.
I. mysql:
Parameter description:
$ User |
$ Password |
$ Targethost |
$ Port |
$ Charset |
$ Dbname |
$ Table |
$ Filename |
User name |
Password |
Ip (localhost) |
Port |
Encoding |
Database name |
Table name (only required for table-level backup) |
File name |
Backup: mysqldump -- single-transaction-l-u $ user-p '$ password'-h $ targethost-P $ port -- default-character-set = $ charset $ dbname $ table> $ filename
Restore: mysql $ dbname-u $ user-p' $ password'-h $ targethost-p $ port -- default-character-set = $ charset <$ filename
II. sqlserver:
Note: sqlserver2003 and below only support osql, sqlserver2005 and above support both osql and sqlcmd. the following methods are applicable to sqlcmd and osql.
Parameter description:
$ User |
$ Passwrod |
$ Instance |
$ Dbname |
$ Filename |
$ Diff_filename |
User name |
Password |
Instance name |
Database name |
Full backup file name |
Incremental backup file name |
Full Backup: osql-U $ user-P "$ password"-d master-S $ instance-Q "alter database $ dbname set offline with rollback immediate; restore database $ dbname from disk = '$ filename' with replace; alter database $ dbname set online"
Incremental Backup: osql-U $ user-P "$ password"-d master-S $ instance-Q "alter database $ dbname set offline with rollback immediate; restore database $ dbname from disk = '$ filename' with replace, NORECOVERY; restore database $ dbname from disk =' $ diff_filename 'with recovery; alter database $ dbname set online"
Full recovery: osql-U $ user-P "$ password"-d master-S $ instance-Q "alter database $ dbname set offline with rollback immediate; restore database $ dbname from disk = '$ filename' with replace; alter database $ dbname set online"
Incremental recovery: osql-U $ user-P "$ password"-d master-S $ instance-Q "alter database $ dbname set offline with rollback immediate; restore database $ dbname from disk = '$ filename' with replace, NORECOVERY; restore database $ dbname from dist =' $ diff_filename 'with recovery; alter database $ dbname set online"
III. oracle:
Oracle uses rman for backup and recovery. if you are interested, you can learn more about the specific use of rman.
IV. redis:
Note: The redis data backup file is stored in the full path file name consisting of dir + dbfilename in the configuration file;
Backup: redis-cli-h targethost-p $ port-a $ password save
Recovery: you only need to store the backup file in the original directory and restart redis.
V. mongo:
Parameter description:
$ Targethost |
$ Port |
$ Dbname |
$ Backup_dir |
$ User |
$ Password |
$ Table |
$ Recovery_dir |
IP address |
Port |
Database name |
Save path |
User name |
Password |
Table name (table-level Recovery) |
Recovery path |
Backup: mongodump -- host $ targethost: $ port-d $ dbname-o $ backup_dir-u $ user-p $ password
Recovery: mongorestore -- host $ targethost: $ port-d $ dbname-u $ user-p $ password-c $ table $ recovery_dir
VI. IPVS:
$ Targethost |
$ Port |
$ User |
$ Dbname |
$ Filename |
$ Recovery_file |
IP address |
End port |
User name |
Database name |
Backup File |
Restore Files |
Backup: pg_dump-c-B-h $ targethost-p $ port-U "$ user" $ dbname> $ filename
Restore: psql-h $ targethost-p $ port-U "$ user"-d $ dbname-f $ recovery_file