| 1 |
DROP TABLE IF EXISTS mysql.mariadb_backup_history; |
| 2 |
SHOW CREATE TABLE mysql.mariadb_backup_history; |
| 3 |
Table Create Table |
| 4 |
mariadb_backup_history CREATE TABLE `mariadb_backup_history` ( |
| 5 |
`uuid` varchar(40) NOT NULL, |
| 6 |
`name` varchar(255) DEFAULT NULL, |
| 7 |
`tool_name` varchar(255) DEFAULT NULL, |
| 8 |
`tool_command` text DEFAULT NULL, |
| 9 |
`tool_version` varchar(255) DEFAULT NULL, |
| 10 |
`ibbackup_version` varchar(255) DEFAULT NULL, |
| 11 |
`server_version` varchar(255) DEFAULT NULL, |
| 12 |
`start_time` timestamp NULL DEFAULT NULL, |
| 13 |
`end_time` timestamp NULL DEFAULT NULL, |
| 14 |
`lock_time` bigint(20) unsigned DEFAULT NULL, |
| 15 |
`binlog_pos` varchar(128) DEFAULT NULL, |
| 16 |
`innodb_from_lsn` bigint(20) unsigned DEFAULT NULL, |
| 17 |
`innodb_to_lsn` bigint(20) unsigned DEFAULT NULL, |
| 18 |
`partial` enum('Y','N') DEFAULT NULL, |
| 19 |
`incremental` enum('Y','N') DEFAULT NULL, |
| 20 |
`format` enum('file','tar','mbstream') DEFAULT NULL, |
| 21 |
`compressed` enum('Y','N') DEFAULT NULL, |
| 22 |
PRIMARY KEY (`uuid`) |
| 23 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci |
| 24 |
SELECT COUNT(*) FROM mysql.mariadb_backup_history; |
| 25 |
COUNT(*) |
| 26 |
1 |
| 27 |
SELECT name FROM mysql.mariadb_backup_history; |
| 28 |
name |
| 29 |
foo |
| 30 |
SELECT COUNT(*) FROM mysql.mariadb_backup_history; |
| 31 |
COUNT(*) |
| 32 |
2 |
| 33 |
SELECT name FROM mysql.mariadb_backup_history; |
| 34 |
name |
| 35 |
|
| 36 |
foo |
| 37 |
DROP TABLE mysql.mariadb_backup_history; |