Hi,
I getting error when import database from mysql8 to 5.7.
http://www.itextpad.com/Lzc8G7Okfu
Please advise.
Thanks.
Dump database, From mysql8 to 5.7
Dump database, From mysql8 to 5.7
|
Sep 25 2021, 10:07 AM, updated 3y ago
Show posts by this member only | Post
#1
|
Senior Member
1,349 posts Joined: Jun 2007 From: /puchong/cyberjaya/klang |
Hi,
I getting error when import database from mysql8 to 5.7. http://www.itextpad.com/Lzc8G7Okfu Please advise. Thanks. |
|
|
|
Sep 25 2021, 10:15 AM
Show posts by this member only | IPv6 | Post
#2
|
Senior Member
1,396 posts Joined: Dec 2012 |
I believe you are trying to import a database that uses a newer version of MySQL to the one that uses the old version of MySQL.
I believe this error happened due to incompatibility. Quickest solution to resolve this error is to replace the collation value in SQL query with "utf8_general_ci" This post has been edited by GOPI56: Sep 25 2021, 10:22 AM |
|
Sep 25 2021, 10:36 AM
Show posts by this member only | Post
#3
|
Senior Member
1,349 posts Joined: Jun 2007 From: /puchong/cyberjaya/klang |
Getting others error.
CODE ERROR 1273 (HY000) at line 344: Unknown collation: 'utf8mb4' This post has been edited by UbuntuClient: Sep 25 2021, 10:36 AM |
|
Sep 25 2021, 10:40 AM
Show posts by this member only | Post
#4
|
Senior Member
1,349 posts Joined: Jun 2007 From: /puchong/cyberjaya/klang |
How to export correctly from mysql8 so it can import to 5.7 without any issue?
|
|
Sep 25 2021, 05:49 PM
Show posts by this member only | Post
#5
|
Senior Member
1,349 posts Joined: Jun 2007 From: /puchong/cyberjaya/klang |
Update:
Problem resolve. CODE find and replace the string “utf8mb4_0900_ai_ci” and replaced it with “utf8mb4_general_ci“. |
Topic ClosedOptions
|
Change to: | 0.0142sec
0.35
5 queries
GZIP Disabled
Time is now: 29th March 2024 - 07:10 PM |