Is it safe to restore a dump taken from mysql 5.6 aws rds instance to mysql 8 aws rds instance? Is there any incompatibilities we should worry about? Thank you.
Asked
Active
Viewed 246 times
0
-
1*Is there any incompatibilities we should worry about?* Yes, they are. But nobody will give complete incompatibilities list. Find (and fix) them in practice. – Akina Feb 15 '22 at 17:04
1 Answers
0
I faced below problem when restoring a dump from MySQL 5.7.16 to MySQL 8.0.28-0ubuntu0.20.04.3
ERROR 1231 (42000) at line 45316: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
The solution that I used ;
sed -i 's/NO_AUTO_CREATE_USER//' my_file.sql
Maybe you might face another problem
You should read Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0
Ergest Basha
- 7,870
- 4
- 8
- 28