#1273 – Unknown collation: ‘utf8_general_ci’

Some time we get the error #1273 – Unknown collation: ‘utf8_general_ci’ when we import the database on different server. This issue occurred due to difference MySQL version.

To fix this problem We have to find the below:
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

and replace with this code:
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

We can also apply the below to solve this problem

Open the database sql file in text editor and

1. Fine: utf8_general_ci Replace: utf8_general_ci (Replace All)

2. Find: utf8_general_ci Replace: utf8_general_ci (Replace All)

3. Find: utf8 Replace: utf8 (Replace All)