Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. UPDATE table SET field = field + 1 WHERE...
  2.  
  3. CREATE DATABASE `test`;
  4. USE test;
  5. CREATE TABLE `serials` (
  6. `id` int(11) NOT NULL AUTO_INCREMENT,
  7. `uuid` varchar(255) NOT NULL,
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `uuid` (`uuid`)
  10. );
  11.  
  12. # Fire one shell with (repeat is zsh syntax)
  13. repeat 2000 mysql test -e "INSERT INTO serials(uuid) VALUES('`uuidgen`')"
  14.  
  15. # Fire another with
  16. mysql-zrm-backup --backup-set localhost --backup-level 0 --verbose; sleep 5; mysql-zrm-backup --backup-set localhost --backup-level 1 --verbose
  17.  
  18. # echo $incrementals | xargs -L 1 mysql-zrm-restore --backup-set $backup_set --source-directory
  19. restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
  20. localhost:restore:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
  21. localhost:restore:INFO: BINLOG = mysqlbinlog --host="localhost" "/var/lib/mysql-zrm/localhost/20141124085026"/mysql-bin.[0-9]* >> /tmp/tLBMtpEZkD
  22. localhost:restore:ERROR: Output of command: 'mysql --host="localhost" -e "source /tmp/tLBMtpEZkD;"' is {
  23. ERROR 1062 (23000) at line 31 in file: '/tmp/tLBMtpEZkD': Duplicate entry '258' for key 'PRIMARY'
  24. }
  25. ERROR: Incremental restore failed
  26. localhost:restore:ERROR: Incremental restore failed
  27. localhost:restore:ERROR: Restore failed
  28.  
  29. # echo $incrementals | xargs -L 1 mysql-zrm-restore --backup-set $backup_set --start-position 881 --source-directory
  30. restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
  31. localhost:restore:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
  32. localhost:restore:INFO: BINLOG = mysqlbinlog --host="localhost" --start-position=881 "/var/lib/mysql-zrm/localhost/20141124085026"/mysql-bin.[0-9]* >> /tmp/YpoSOEFMi1
  33. localhost:restore:INFO: Incremental restore done
  34. localhost:restore:INFO: Restore done in 1 seconds.
  35.  
  36. localhost:backup:INFO: {
  37. localhost:backup:INFO: retention-policy=10D
  38. localhost:backup:INFO: backup-level=0
  39. localhost:backup:INFO: mailto=root@localhost
  40. localhost:backup:INFO: all-databases=1
  41. localhost:backup:INFO: databases=test
  42. localhost:backup:INFO: host=localhost
  43. localhost:backup:INFO: database=test
  44. localhost:backup:INFO: single-transaction=only-innodb
  45. localhost:backup:INFO: mail-policy=only-on-error
  46. localhost:backup:INFO: backup-mode=logical
  47. localhost:backup:INFO: backup-type=regular
  48. localhost:backup:INFO: compress=
  49. localhost:backup:INFO: mysql-binlog-path=/var/log/mysql
  50. localhost:backup:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
  51. localhost:backup:INFO: }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement