# Problem with the compatibility of sql files

**URL:** https://forum.codewithmosh.com/t/problem-with-the-compatibility-of-sql-files/17558
**Category:** SQL
**Created:** [January 9, 2023, 11:44pm UTC](https://forum.codewithmosh.com/t/problem-with-the-compatibility-of-sql-files/17558 "2023-01-09T23:44:17Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sarabi](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@sarabi](https://forum.codewithmosh.com/u/sarabi)
#### Post date: [January 9, 2023, 11:44pm UTC](https://forum.codewithmosh.com/t/problem-with-the-compatibility-of-sql-files/17558/1 "2023-01-09T23:44:17Z")

</div>

I need a solution :  
18:33:10 CREATE TABLE `payment_methods` ( `payment_method_id` tinyint(4) NOT NULL AUTO\_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`payment_method_id`) ) ENGINE=InnoDB AUTO\_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4\_0900\_ai\_ci Error Code: 1273. Unknown collation: ‘utf8mb4\_0900\_ai\_ci’ 0.000 sec

---

<div class="post-metadata">

### Author: ![SAM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/sam/32/167_2.png) [@SAM](https://forum.codewithmosh.com/u/SAM)
#### Post date: [January 10, 2023, 5:40am UTC](https://forum.codewithmosh.com/t/problem-with-the-compatibility-of-sql-files/17558/2 "2023-01-10T05:40:05Z")

</div>

Your MySQL server is probably too old. You can see the version in MySQL Workbench via Server/Status. Mosh uses version 8.0.15.

---

<div class="post-metadata">

### Author: ![sarabi](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@sarabi](https://forum.codewithmosh.com/u/sarabi)
#### Post date: [January 12, 2023, 5:39pm UTC](https://forum.codewithmosh.com/t/problem-with-the-compatibility-of-sql-files/17558/3 "2023-01-12T17:39:58Z")

</div>

I actually solved it by deleting an extra line he added for some reason.