# How do I restore a mysql 5.6 source backup on a server with mysql community server 8? **URL:** \ **Category:** Percona XtraBackup\ **Tags:** mysql, percona\ **Created:** [December 3, 2020, 5:53pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339 "2020-12-03T17:53:36Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![CESAR\_MURILO\_DA\_SILV](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cesar_murilo_da_silv/32/1248_2.png) [@CESAR\_MURILO\_DA\_SILV](https://forums.percona.com/u/CESAR_MURILO_DA_SILV)\ **Post date:** [December 3, 2020, 5:53pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/1 "2020-12-03T17:53:36Z")
Backup on a server with Slackware 14.2, mariadb 10 (we can say mysql 5.6) and Percona Xtrabackup 2.3; and it must be restored on an Ubuntu Server 20.04 LTS, which has MySQL Server Community 8. I tried, at first, with Xtrabackup 8, which doesn’t have the innobackupex tool, so I had to go back, on this server, to Xtrabackup 2.4. Only after I restored it, mysql does not start, saying that the data dictionary is being updated, but remains in this error. ---
**Author:** ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)\ **Post date:** [December 3, 2020, 6:09pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/2 "2020-12-03T18:09:33Z")
You must ‘upgrade’ through every major version, please see [https://forums.percona.com/discussion/56517/restore-on-different-version#latest](https://forums.percona.com/discussion/56517/restore-on-different-version#latest) – George O. Lorch III Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup ---
**Author:** ![CESAR\_MURILO\_DA\_SILV](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cesar_murilo_da_silv/32/1248_2.png) [@CESAR\_MURILO\_DA\_SILV](https://forums.percona.com/u/CESAR_MURILO_DA_SILV)\ **Post date:** [December 3, 2020, 8:34pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/3 "2020-12-03T20:34:23Z")
I don’t know what to do, it seems that there is no easy solution. Or I upgrade Slackware to the Current version, and it will have to be offline (this complicates). Or I install mysql 5.6 [(via debian packages](https://downloads.mysql.com/archives/community/)) on Ubuntu Server to later upgrade, but I would need percona xtrabackup 2.3.9 (to restore and then upgrade mysql), and I can’t find it for download anymore, just 2.4 or 8. ---
**Author:** ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)\ **Post date:** [December 3, 2020, 8:47pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/4 "2020-12-03T20:47:31Z")
PXB 2.4 can backup and prepare both 5.6 and 5.7. Regardless though, you still must restore your 5.6 backup to a 5.6 server instance, then upgrade that instance to 5.7, and then to 8.0. The only other option is to perform a logical dump via mysqldump and load directly into a fresh 8.0 instance. – George O. Lorch III Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup ---
**Author:** ![CESAR\_MURILO\_DA\_SILV](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cesar_murilo_da_silv/32/1248_2.png) [@CESAR\_MURILO\_DA\_SILV](https://forums.percona.com/u/CESAR_MURILO_DA_SILV)\ **Post date:** [December 3, 2020, 8:53pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/5 "2020-12-03T20:53:04Z")
I’ll do a test. I will install MySQL 5.6 on Ubuntu Server 20.04, do the restoration, and then do the upgrade gradually. I’ll be back later with the test results. ---
**Author:** ![CESAR\_MURILO\_DA\_SILV](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cesar_murilo_da_silv/32/1248_2.png) [@CESAR\_MURILO\_DA\_SILV](https://forums.percona.com/u/CESAR_MURILO_DA_SILV)\ **Post date:** [December 6, 2020, 1:28pm UTC](https://forums.percona.com/t/how-do-i-restore-a-mysql-5-6-source-backup-on-a-server-with-mysql-community-server-8/8339/6 "2020-12-06T13:28:27Z")
By the recovery method of Percona Xtrabackup I was not able to, I only managed to do the mysqldump of the Zabbix database that I wanted and recover it directly in MySQL Community Server 8. Percona Xtrabackup: I test recovering the bank with xtrabackup 2.4 in MySQL 5.6, then I upgraded to MySQL 5.7, but then mysql\_upgrade could not be executed because it said that the password had expired, and I was unable to change it. it because it said that the MySQL user table had 45 columns and the experience was that it had 44. That is, there were a series of problems.