Hibiscus Technolab

Question:

====

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’

 

Solution

===

You can solve this by finding

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

in your .sql file, and swapping it with

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Elina Carter

Elina Carter

Elina is a content strategist and digital solutions expert at Hibiscus Technolab. With a keen eye for design trends and a passion for crafting user-first web experiences, she specializes in helping businesses grow through tailored WordPress development, SEO, and marketing solutions. When she's not optimizing websites, you’ll find her exploring UI/UX innovations or writing about the latest in digital technology.

Elina Carter

Elina is a content strategist and digital solutions expert at Hibiscus Technolab. With a keen eye for design trends and a passion for crafting user-first web experiences, she specializes in helping businesses grow through tailored WordPress development, SEO, and marketing solutions. When she's not optimizing websites, you’ll find her exploring UI/UX innovations or writing about the latest in digital technology.

https://hibiscustechnolab.com