Restoring 5.7.31 to 8.0.x MySQL Database using Xtrabackup

I have a 3 server replication of 1 source and 2 read-only replicas running on 5.7.31-log Community. I want to add a new, 3rd read-only replica on mysql v8.0.27 (all ubuntu). I was following a guide using mysqldump and run into an issue. Someone suggested Xtrabackup. Procedure looks straight FWD following this guide:

using mysqldump - MySQL Replication Setup without Downtime | Linux Scripts Hub
xtrabackup - percona.com/doc/percona-xtrabackup/8.0/howtos/setting_up_replication.html

I guess my first question is the most basic, is a mysqldump backup of v5.7 compatible with v8? Doing a full I do not know. I have done v5.7 backups of selecting out multiple databases and importing them into v8 with success.

Second, can I use a xtrabackup from v5.7 and import it into a v8 mysql, following the procedure above?

Thanks!
DD

Here’s my original Reddit; www.reddit.com/r/mysql/comments/sdchf9/mysql_import_access_to_system_table_mysqlinnodb

1 Like