Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE table SET field = field + 1 WHERE...
- CREATE DATABASE `test`;
- USE test;
- CREATE TABLE `serials` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `uuid` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `uuid` (`uuid`)
- );
- # Fire one shell with (repeat is zsh syntax)
- repeat 2000 mysql test -e "INSERT INTO serials(uuid) VALUES('`uuidgen`')"
- # Fire another with
- mysql-zrm-backup --backup-set localhost --backup-level 0 --verbose; sleep 5; mysql-zrm-backup --backup-set localhost --backup-level 1 --verbose
- # echo $incrementals | xargs -L 1 mysql-zrm-restore --backup-set $backup_set --source-directory
- restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
- localhost:restore:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
- localhost:restore:INFO: BINLOG = mysqlbinlog --host="localhost" "/var/lib/mysql-zrm/localhost/20141124085026"/mysql-bin.[0-9]* >> /tmp/tLBMtpEZkD
- localhost:restore:ERROR: Output of command: 'mysql --host="localhost" -e "source /tmp/tLBMtpEZkD;"' is {
- ERROR 1062 (23000) at line 31 in file: '/tmp/tLBMtpEZkD': Duplicate entry '258' for key 'PRIMARY'
- }
- ERROR: Incremental restore failed
- localhost:restore:ERROR: Incremental restore failed
- localhost:restore:ERROR: Restore failed
- # echo $incrementals | xargs -L 1 mysql-zrm-restore --backup-set $backup_set --start-position 881 --source-directory
- restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
- localhost:restore:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
- localhost:restore:INFO: BINLOG = mysqlbinlog --host="localhost" --start-position=881 "/var/lib/mysql-zrm/localhost/20141124085026"/mysql-bin.[0-9]* >> /tmp/YpoSOEFMi1
- localhost:restore:INFO: Incremental restore done
- localhost:restore:INFO: Restore done in 1 seconds.
- localhost:backup:INFO: {
- localhost:backup:INFO: retention-policy=10D
- localhost:backup:INFO: backup-level=0
- localhost:backup:INFO: mailto=root@localhost
- localhost:backup:INFO: all-databases=1
- localhost:backup:INFO: databases=test
- localhost:backup:INFO: host=localhost
- localhost:backup:INFO: database=test
- localhost:backup:INFO: single-transaction=only-innodb
- localhost:backup:INFO: mail-policy=only-on-error
- localhost:backup:INFO: backup-mode=logical
- localhost:backup:INFO: backup-type=regular
- localhost:backup:INFO: compress=
- localhost:backup:INFO: mysql-binlog-path=/var/log/mysql
- localhost:backup:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
- localhost:backup:INFO: }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement