When executing the backup command, the backup type, duration condition, and backup destination path must be defined. To back up the entire database, you must specify "DATABASE". To back up specific tables, specify "TABLE" as the backup type. When backing up specific tables, you must specify the table name.
You can specify the backup destination using the DURATION conditional statement. Specify the start time and end time of the backup target data in the FROM and TO clauses. In the example above, "2015-07-14 00:00:00" is defined as FROM and "2015-07-14 23:59:59" is defined as TO, so the user will be able to see all data for July 14, 2015 Quot; Duration If you do not specify a time condition, "1970-01-01 00:00:00" is set to FROM and the current time at which it is executed is set in the TO clause.
Specify "IBFILE" to create a backup file as a single file, or "DISK" as a backup option to create multiple files and directories. Note that when specifying a backup path, backup files are created under "$ MACHBASE_HOME / dbs" when a relative path is specified. To specify an absolute path, you must always set a path that starts with "/".
When restoring data from a backup file, it can not be executed by a query command, and the command "machadmin -r" should be executed in a situation where the database does not operate. Before running the backup, you should review for the following conditions:
- Is the Machbase database down?
- Is the current database deleted and replaced with the data to be recovered, and is the deletion of the current database allowed?
Single Backup File Extraction
Single backup file (IBFILE) can not be used immediately for recovery. After extracting the data with the "machadmin" tool, the backup files are created in the "target_path/backup_file_name/" directory.
Single Backup File Information Confirmation
The single backup file information created by the backup command can be confirmed by machadmin -w command.
The displayed information includes the name of the backup file, the date of creation, the start time of the backed up data, the end time, and the version of the backed-up database.