Error Importing data to MySQL Group Replication

626 views Asked by At

I'm taking a backup from a standalone database using the following command:

mysqldump -u <user> -p --databases <some databases> --no-create-info --no-create-db --skip-triggers --single-transaction --compress --order-by-primary > data.sql

When I'm importing the data into a MySQL Group Replication, I get this error:

ERROR 3098 (HY000) at line 2150: The table does not comply with the requirements by an xternal plugin.

The last line that the restore ran was: alter table disable keys and the error stopped appearing when the alter table enable keys.

1

There are 1 answers

0
Tal Ayalon On BEST ANSWER

Managed to figure it out. One of the MySQL GroupReplication requirements is to have a Primary Key for each table. Unlike Standalone Mysql that doesn't require it. I took the data from a Standalone Mysql and tried to import it into a Group Replication. As I find out, only 1 table didn't have a Primary Key so the import always failed on that table with that error.