What kind of complications would I face downgrading from MySQL 8 to MySQL 5?
1
vote
0
answers
310
views
Let's assume I wanted to downgrade to from MySQL 8 to MySQL 5.7. [I know this isn't supported](https://dev.mysql.com/doc/refman/8.0/en/downgrading.html) , but what kind of complications am I likely to encounter.
The docs say,
> The only supported alternative is to restore a backup taken ***before*** upgrading. It is therefore imperative that you backup your data ***before*** starting the upgrade process.
Let's say I buck the caveat, and dump on 8 and revive on 5.7? What should I expect? [Dumping on 5.x would product comments like](https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html)
/*!40101 SET character_set_client = @saved_cs_client */;
These comments are documented as,
> If you add a version number after the
!
character, the syntax within the comment is executed **only if the MySQL version is greater than or equal to the specified version number**.
Are those kind of comments still produced by version 8? If so, what kind of scenarios would they not cover?
Asked by Evan Carroll
(65502 rep)
Feb 14, 2020, 04:27 PM
Last activity: Feb 19, 2020, 09:40 PM
Last activity: Feb 19, 2020, 09:40 PM