Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Issues

Select view

Select search mode

 
29 of 29

高版本的XtraBackup无法备份低版本的MySQL db

Not a Bug

Description

我使用xtrbackup2.4.22备份mysql 社区版5.5.21时候，报错：

Error: failed to execute query 'SELECT NAME, SPACE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES': 1109 (42S02) Unknown table 'INNODB_SYS_TABLES' in information_schema

 

Environment

软件版本信息：

root@d12070747 v3]# xtrabackup --version
xtrabackup: recognized server arguments:
xtrabackup version 2.4.22 based on MySQL server 5.7.32 Linux (x86_64) (revision id: c99a781)
[root@d12070747 v3]#
[root@d12070747 v3]#
[root@d12070747 v3]# mysql --version
mysql Ver 14.14 Distrib 5.5.21, for Linux (x86_64) using readline 5.1
[root@d12070747 v3]#

[root@d12070747 3308_housebaidu_20210628]# cat /etc/redhat-release
CentOS release 6.5 (Final)
[root@d12070747 3308_housebaidu_20210628]#

Attachments

2

Smart Checklist

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Smart Checklist

Created June 28, 2021 at 9:33 AM
Updated March 6, 2024 at 6:38 PM
Resolved July 7, 2021 at 4:42 PM
Configure

Activity

Show:

Marcelo Altmann July 7, 2021 at 4:41 PM

Hi  

 

The issue you are seeing is because MySQL 5.5 doesn't have the table PXB requires to avoid DDL's happening during the backup. You can try to take the backups without --lock-ddl-per-table.

 

Your version 5.5 it's been EOL for a long time already. In fact, the next major series 5.6 is also EOL. We highly advise you to upgrade your server to either 5.7 or 8.0.

 

 

Loading...