Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 Dump database, From mysql8 to 5.7

views
     
TSUbuntuClient
post Sep 25 2021, 10:07 AM, updated 3y ago

Regular
******
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.
GOPI56
post Sep 25 2021, 10:15 AM

Regular
******
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
TSUbuntuClient
post Sep 25 2021, 10:36 AM

Regular
******
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
TSUbuntuClient
post Sep 25 2021, 10:40 AM

Regular
******
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?
TSUbuntuClient
post Sep 25 2021, 05:49 PM

Regular
******
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:
| Lo-Fi Version
0.0142sec    0.35    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 07:10 PM