Title: Database Import Problem Stopwords-Table Collation Error
Last modified: August 30, 2016

---

# Database Import Problem Stopwords-Table Collation Error

 *  [Lschreyer](https://wordpress.org/support/users/lschreyer/)
 * (@lschreyer)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-import-problem-stopwords-table-collation-error/)
 * Hello,
 * I exported my database to import the data into a new mysql-server.
    I receive
   the error
 * #1253 – COLLATION ‘utf8_bin’ is not valid for CHARACTER SET ‘utf8mb4’
 * The exported SQL statement is
 * `CREATE TABLE`wp_relevanssi_stopwords` (
    `stopword` varchar(50) CHARACTER SET
   utf8mb4 COLLATE utf8_bin NOT NULL, UNIQUE KEY `stopword` (`stopword`) ) ENGINE
   =InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;`
 * How can I change this to work?
 * It seems that the utf8_bin is not correct. I guess it should be “utf8mb4_bin”
 * Am I right? Why is this exported wrong? The error comes up after updating to 
   the latest version today.
 * [https://wordpress.org/plugins/relevanssi/](https://wordpress.org/plugins/relevanssi/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * (@msaari)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/database-import-problem-stopwords-table-collation-error/#post-6270974)
 * Yeah, fix that manually. The problem is probably caused by switching versions
   somewhere – it used to be utf8 and utf8_bin, now it’s utf8mb4 and utf8mb4_bin.
   In a new installation Relevanssi will get the collation right, but yours is somehow
   a mix between old and new. Best fix it manually, then.
 *  [H. Adam Lenz](https://wordpress.org/support/users/adrock42/)
 * (@adrock42)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-import-problem-stopwords-table-collation-error/#post-6271106)
 * In multisite, this issue does not go away. When a new site is created it gets
   utf8_bin applied and the same issue arrises
 *  Plugin Author [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * (@msaari)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-import-problem-stopwords-table-collation-error/#post-6271107)
 * Can you give [the development version](https://downloads.wordpress.org/plugin/relevanssi.zip)
   a go and see if that works better?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database Import Problem Stopwords-Table Collation Error’ is closed to
new replies.

 * ![](https://ps.w.org/relevanssi/assets/icon-256x256.png?rev=3529670)
 * [Relevanssi - A Better Search](https://wordpress.org/plugins/relevanssi/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/relevanssi/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/relevanssi/)
 * [Active Topics](https://wordpress.org/support/plugin/relevanssi/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/relevanssi/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/relevanssi/reviews/)

## Tags

 * [collation](https://wordpress.org/support/topic-tag/collation/)

 * 3 replies
 * 3 participants
 * Last reply from: [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/database-import-problem-stopwords-table-collation-error/#post-6271107)
 * Status: not resolved