SpecialistOff.NET / Вопросы / Статьи / Фрагменты кода / Резюме / Метки / Помощь / Файлы
Список вопросов ПечатьМетки: percona xtrabackup xtrabackup mysql
$ xtrabackup --backup --target-dir=~/backups/
2023-01-11T16:25:22.447152+03:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --server-id=3 --log_bin=/var/log/mysql/mysql-bin.log --innodb_buffer_pool_size=1G --innodb_log_file_size=256M --innodb_read_io_threads=64 --innodb_write_io_threads=64
2023-01-11T16:25:22.447334+03:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --backup=1 --target-dir=~/backups/ --user=root --password=*
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
230111 16:25:22 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
230111 16:25:22 version_check Connected to MySQL server
230111 16:25:22 version_check Executing a version check against the server...
230111 16:25:22 version_check Done.
2023-01-11T16:25:22.540686+03:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
2023-01-11T16:25:22.556991+03:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.30-0ubuntu0.20.04.2
2023-01-11T16:25:22.561156+03:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2023-01-11T16:25:22.573903+03:00 0 [ERROR] [MY-011825] [Xtrabackup] Found tables with row versions due to INSTANT ADD/DROP columns
2023-01-11T16:25:22.573987+03:00 0 [ERROR] [MY-011825] [Xtrabackup] This feature is not stable and will cause backup corruption.
2023-01-11T16:25:22.574013+03:00 0 [ERROR] [MY-011825] [Xtrabackup] Please check https://docs.percona.com/percona-xtrabackup/8.0/em/instant.html for more details.
2023-01-11T16:25:22.574038+03:00 0 [ERROR] [MY-011825] [Xtrabackup] Tables found:
2023-01-11T16:25:22.574062+03:00 0 [ERROR] [MY-011825] [Xtrabackup] db/table1
2023-01-11T16:25:22.574083+03:00 0 [ERROR] [MY-011825] [Xtrabackup] db/table2
2023-01-11T16:25:22.574104+03:00 0 [ERROR] [MY-011825] [Xtrabackup] Please run OPTIMIZE TABLE or ALTER TABLE ALGORITHM=COPY on all listed tables to fix this issue.