CODEWITHSUNDEEP
mysqlphpmyadmindatabase-replication
HuwD
HuwD

Reputation: 1800

phpMyAdmin replication

Am trying to set up replication between two servers but keep getting the following errorenter image description here

Full Query says: 

SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci';

Both master and slave database have collation set as utf8_general_ci.

Any ideas?

Upvotes: 2

Views: 1548

Answers (2)

HuwD
HuwD

Reputation: 1800

Thanks for all the help. In the end just uninstalled MySQL and installed an earlier version. They seem to be talking to each other now.

Upvotes: 0

Carlos Robles
Carlos Robles

Reputation: 10947

please, check if in the destination server you have that collation and charset available. You can do it with 

SHOW CHARACTER SET

http://dev.mysql.com/doc/refman/5.0/en/show-character-set.html

and 

SHOW COLLATION

http://dev.mysql.com/doc/refman/5.0/en/show-collation.html

Upvotes: 1

Related Questions