1
  • Master A mysql 8
  • Master B mysql 5.7
  • Master C mysql 5.7
  • Slave mysql 8

i create 4 channels on my slave and i can not restore backup from master.

[root@CentOS-76-64-minimal hex]# gunzip < db.gz | mysql -u root -p
Enter password:
ERROR 3079 (HY000) at line 22: Multiple channels exist on the slave. Please provide channel name as an argument.
  • 3 Masters in a circle? Ugh. – Rick James Jun 8 '19 at 5:28
  • 1
    3 different master and one slave (for backup) – Goran Siriev Jun 8 '19 at 7:26
-1

Try this

mysql> create database mydb;
mysql> use mydb;
mysql> source db_backup.dump;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.