While transfering the site from one server to another server, some times we face “#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’”. Simple follow below steps :

find this
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

and change
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

1) CHARSET=utf8mb4
Replace CHARSET=utf8mb4 with CHARSET=utf8

2) COLLATE=utf8mb4_unicode_520_ci
Replace COLLATE=utf8mb4_unicode_520_ci with COLLATE=utf8_general_ci

3 ) utf8mb4_unicode_520_ci
Replace utf8mb4_unicode_520_ci with utf8_general_ci

Now your database is ready to move on new demo server. 🙂

There are currently no comments.