mysql slave restore database ERROR 3079

Posted on

Question :

  • 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.

Answer :

Try this

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

Leave a Reply

Your email address will not be published. Required fields are marked *