# can we use xtrabackup 2.4.20 to backup community edition of MYSQL 5.16 ? **URL:** \ **Category:** Percona XtraBackup\ **Created:** [August 28, 2020, 2:16pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979 "2020-08-28T14:16:34Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [August 28, 2020, 2:16pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/1 "2020-08-28T14:16:34Z")
can we use xtrabackup 2.4.20 to backup community edition of MYSQL 5.16 ? during prepare phase getting error InnoDB: 5.7.26 started; log sequence number 16976204771688 InnoDB: Cannot add field `a_str_131` in table `DB123`.`task` because after adding it, the row size is 8166 which is greater than maximum allowed size (8126) for a record on index leaf page. ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [August 30, 2020, 7:25pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/2 "2020-08-30T19:25:39Z")
Do you mean MySQL version 5.7.16? In any case, Xtrabackup 2.4.20 should work with MySQL Community edition 5.7. If I understand correctly, this happens during prepare (restore). Please check and compare the configuration between source and destination instances (eg innodb\_page\_size, default character set, etc).Please provide full output of the table structure for DB123.task table. ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [August 31, 2020, 9:08pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/3 "2020-08-31T21:08:16Z")
Thanks for prompt response . We are using My SQL Server version: 5.6.16-log MySQL Community Server. Can we use Xtrabackup 2.4.20 to backup and restore MySQL 5.6.16? While decompress we are getting xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86\_64) (revision id: c8b4056) 200831 22:34:12 [01] decompressing ./xtrabackup\_logfile.qp 200831 22:34:12 [02] decompressing ./mysql/innodb\_index\_stats.ibd.qp 200831 22:34:12 [03] decompressing ./mysql/slave\_relay\_log\_info.ibd.qp sh: qpress: command not found ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 5, 2020, 4:51am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/4 "2020-09-05T04:51:33Z")
You are missing the qpress package. If you are using CentOS/RHEL 7 you can download it here: [https://repo.percona.com/yum/release/centos/7/RPMS/x86\_64/qpress-11-1.el7.x86\_64.rpm](https://repo.percona.com/yum/release/centos/7/RPMS/x86_64/qpress-11-1.el7.x86_64.rpm) ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 5, 2020, 11:35am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/5 "2020-09-05T11:35:22Z")
@jrivera Thanks for your response on decompressing We are using My SQL Server version: 5.6.16 MySQL Community Server. Can we use Xtrabackup 2.4.20 to backup and restore MySQL 5.6.16? or do we need to install any older version of xtrabackup? ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 8, 2020, 5:33am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/6 "2020-09-08T05:33:26Z")
@jrivera Can we use Xtrabackup 2.4.20 to backup and restore MySQL 5.6.16  Thanks ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 8, 2020, 5:36am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/7 "2020-09-08T05:36:52Z")
Xtrabackup 2.4.20 should work, however, due to the version of MySQL being too old. It may be good to use Xtrabackup 2.3 instead. Are you backing up and restoring to the same MySQL version? ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 8, 2020, 5:40am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/8 "2020-09-08T05:40:02Z")
Thanks . We are backing up and restoring to same version of MySQL 5.6.16 . Which version of xtrabackup you 2.3 we need to down load ? ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 8, 2020, 5:41am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/9 "2020-09-08T05:41:05Z")
We generally recommend using the latest version available for PXB 2.3 series. ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 8, 2020, 5:42am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/10 "2020-09-08T05:42:47Z")
Can you please provide the link . Not able to find down load link for redhat 6.x ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 8, 2020, 11:45am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/11 "2020-09-08T11:45:06Z")
@jrivera can you please provide link to down load PXB2.3 fro backing up MySQL 5.6 ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 9, 2020, 10:22pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/12 "2020-09-09T22:22:48Z")
@kduvvuri note that PXB 2.3 has already reached EOL. Can you try using Percona Xtrabackup 2.4 first and let us know if you encounter any issues? ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 10, 2020, 10:18am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/13 "2020-09-10T10:18:11Z")
@jrivera backup using version 2.4.20 worked  , backup detected MYSQL **Using server version 5.6.16-log**   The prepare command was also success full , and got message **InnoDB: 5.7.26 started** ; log sequence number 17226588601877 Are we good to use xtrabackup 2.4.20 for MySQL 5.6 ? As per extra backup page [https://www.percona.com/doc/percona-xtrabackup/2.4/index.html](https://www.percona.com/doc/percona-xtrabackup/2.4/index.html "Link: https://www.percona.com/doc/percona-xtrabackup/2.4/index.html") here it says It can back up data from _InnoDB_, _XtraDB_, and _MyISAM_ tables on _MySQL_ 5.1 [1], 5.5, 5.6 and 5.7 servers, as well as _Percona Server for MySQL_ with _XtraDB_ xtrabackup --defaults-extra-file=/glide/backup/xtrabkp/xbk.cnf --parallel=4 --backup --target-dir=/glide/backup/xtrabkp/bkp 200908 17:15:18  version\_check Connecting to MySQL server with DSN'dbi:mysql:;mysql\_read\_default\_group=xtrabackup;host=localhost;port=3306;mysql\_socket=/tmp/mysql.sock' as 'root'  (using password: YES). 200908 17:15:18  version\_check Connected to MySQL server 200908 17:15:18  version\_check Executing a version check against the server... 200908 17:15:18  version\_check Done. 200908 17:15:18 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock **Using server version 5.6.16-log** **xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86\_64)** (revision id: c8b4056) Prepare command xtrabackup --defaults-extra-file=/glide/backup/xtrabkp/xbk.cnf --parallel=4 --prepare --target-dir=/glide/backup/xtrabkp/bkp **InnoDB: 5.7.26 started** ; log sequence number 17226588601877 InnoDB: page\_cleaner: 1000ms intended loop took 7890ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) xtrabackup: starting shutdown with innodb\_fast\_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 17226588601896 200908 17:28:25 completed OK! ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 16, 2020, 8:38am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/14 "2020-09-16T08:38:48Z")
@jrivera can you please advice if we are good to use percona xtrabackup .Backup worked fine on 5.6.16 . During prepare phase we got **InnoDB: 5.7.26 started** ; log sequence number 17226588601877 for mysql5.6.16 ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 17, 2020, 2:44am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/15 "2020-09-17T02:44:27Z")
@kduvvuri Percona XtraBackup 2.4.20 should be fine then. Did you try and start up the prepared backup on a test v5.6.16 instance or not? ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 17, 2020, 12:48pm UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/16 "2020-09-17T12:48:26Z")
@jrivera I will test and update this forum ---
**Author:** ![kduvvuri](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@kduvvuri](https://forums.percona.com/u/kduvvuri)\ **Post date:** [September 21, 2020, 9:36am UTC](https://forums.percona.com/t/can-we-use-xtrabackup-2-4-20-to-backup-community-edition-of-mysql-5-16/7979/17 "2020-09-21T09:36:21Z")
@jrivera I was able to backup MySQL V5.6.16 on RHEL 6.x using xtra backup 2.4.20 , restore the database on rhel7.x . After restore on target server innodb\_version | 5.6.16 . Looks like we can use xtra backup 2.4.20 to backup and restore older version MySQL 5.6.16 Thanks for your prompt response