I have a WordPress website on my local WAMP server. But when I upload its database to live server, I get error
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
Any help would be appreciated!
To solve the error, try using the below code:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
The .sql file can be swapped it with below code:
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;