Backup and recovery of KingbaseES

Backup and recovery of KingbaseES 1. the database that backs up and recovers KingbaseES databases uses its command line tool sys_dump.exe. Its usage is as follows (): sys_dump.exe-h server_name-p 54321-U user_name-W password-B-f backup_file_path database_name slightly parses the meaning of the preceding command line parameters: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password backup_file_path -- backup file path database_name -- Database Name: sys_dump.exe-h \ 192.168.1.1-p 54321-U zjc-W 123456-B-f D: \ BakeFile. dmp T Two steps are taken to restore the database of echInfo KingbaseES: the first step is to execute an SQL statement to create an empty data: [SQL] create database database_name -- create an empty database. The second step is to use the database restoration tool sys_restore.exe to import data to the database from the backup file. Its usage is as follows (): sys_restore.exe-h server_name-p 54321-U user_name-W password-d database_name backup_file_path slightly parses the meaning of the preceding command line parameters: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password database_name -- database name backup_file_path -- backup file path example: s Ys_restore.exe-h \ 192.168.1.1-p 54321-U zjc-W 123456-d TechInfo D: \ BackupFile. dmpTechInfo 1. mode backup and recovery before introducing the mode backup and recovery of KingbaseES, let's briefly explain what the KingbaseES mode refers? The Schema of KingbaseES is actually a namespace that contains named objects (tables, views, stored procedures, functions, and sequences ). The pattern of kingbaseesuses its command line tool sys_dump.exe. Its usage is as follows (): sys_dump.exe-h server_name-p 54321-U user_name-W password-n schema_name-B-f backup_file_path database_name slightly parses the meaning of the preceding command line parameters: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password schema_name -- Mode name backup_file_path -- backup file path database_name -- Database Name an example is: sys_dump.exe-h \ 192.168.1.1-p 54321-U zjc-w 123456 cug-B-f D: \ BakeFile. Dmp TechInfo kingbaseesschema-level recovery refers to its command line tool sys_restore.exe, which uses methods such as sys_restore.exe-h server_name-p 54321-U user_name-W password-d database_name backup_file_path slightly parses the preceding command line parameter meaning: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password database_name -- database name backup_file_path -- An Example of the backup file path is as follows: sys_restore.exe-h \ 192.168.1.1-p 54321-U zjc-W 123456-d TechInfo D: \ BackupFile. dmpTechInfo 2. the system still uses sys_dump.exe to back up and restore the records of kingbasees. its usage is as follows: sys_dump.exe-h server_name-p 54321-U user_name-W password-t schema. table_name-B-f backup_file_pathdatabase_name slightly parses the meaning of the preceding command line parameters: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password backup_file_path -- backup file path database_name -- Database Name: sys_dump.exe-h \ 192.168.1.1-p 54321-U zjc-W 123456-B-f D: \ BakeFile. dmp T EchInfo kingbaseesrecord table level recovery uses its command line tool sys_restore.exe, as shown in sys_restore.exe-h server_name-p 54321-U user_name-W password-d database_name backup_file_path slightly parses the preceding command line parameter meaning: server_name -- database server name or Database Server IP address user_name -- database Username password -- database logon password database_name -- database name backup_file_path -- An Example of the backup file path is as follows: sys_restore.exe-h \ 192.168.1.1-p 54321-U zjc-W 123456-d TechInfo D: \ BackupFile. dmpTechInfo can be seen The usage of mode-level recovery and record-level recovery is the same.