MySQL v5.7 and v8.0 can't use the same data
I took me days to upgrade to MySQL v8.0 (back up the data folder, delete it, do some hack in the my.ini, then restore data...), and it seems that I can't use the same data folder for both version.
Is there any way to separate the data folder for each one of them?
Please help! Thank you!
@An-De : Can you try changing the
Btw the safe processes to upgrade is:
- Dump all databases to sql:
mysqldump.exe --all-databases > C:\laragon\tmp\alldb.sql
Add new MySQL version (v8.0) in your case:
Restore from the sql:
myql -u root -p < C:\laragon\tmp\alldb.sql
@leokhoa I have tried to change the datadir in my.ini, but every time I restart, it automatically changes back to the path that is set in the preferences.
@An-De : Let me check my code and fix it.