That gives me some time to work with 5.7 and figure out what I need to do to get 8 working later on. I have tested using it and it seems fairly straightforward.Īnyway, from what I've looked at, I will probably only need MySQL 8 for the lessons relating to CTEs, since they are unsupported by MySQL previous to that. Last edit at 10:56AM by Otomatic.Īs I said I don't need to copy any data yet, so that part doesn't concern me as much - although I should apparently just use mysqldump. « It's not because they are many to be wrong, they are necessarily right. « Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison.
PhPMyadmin 5.1.3 - MysqlDumper 1.24.5 on W10 and W7 Pro 64 bitĭocumentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
This way of doing it while wanting to use a version under development shows the little seriousness of such courses. The "lessons" that ask you to use MySQL 8 are irresponsible. Wamp64\bin\mysql\mysql8.0.2\bin\mysqld.exe -initialize-insecure Just a small indication to create the data folder, but not sure it is still valid for branch 8: Huge mistake! The data folder should never be copied between different versions of MySQL and it never works between different branches. > - Copy the data folder from mysql5.7.14 to mysql8.0.2 Upgrades between milestone releases (or from a milestone release to a GA release) are not supported. MySQL says: This is a milestone release, for use at your own risk. Versions can evolve from one day to the next without any guarantee of compatibility between these versions.
I hit enter because no password is set, and the command window says "ERROR (something something)" and instantly closes.īranch 8 of MySQL is a branch under development. If I try to run the MySQL console, a command window opens and asks for a password. If I hover it, it says "local server - 1 of 2 services running". At this point, the WampServer icon in my taskbar is orange. I click on mysql8.0.2 and a command window quickly opens and closes. Edit mysql8.0.2/my.ini and replace all instances of mysql5.7.14 with mysql8.0.2 (then save)Īt this point, if I hover MySQL -> Version in my taskbar, it shows 5.7.14 with a check, and 8.0.2 below it. Copy my.ini from mysql5.7.14 to mysql8.0.2 Copy the data folder from mysql5.7.14 to mysql8.0.2 Copy the contents of the folder to a new mysql subdirectory, e.g.
Download MySQL version and extract to a folder, e.g.
I do not have any databases that require backing up, so that is not a concern at this point, though of course I will need to know how to do so eventually.įrom what I understand, the steps are something like the following:
I know it is possible to set up Wamp to work with multiple versions of a language, but after hours of attempts and following various directions found through Google, I have not been able to successfully get this working. Everything works fine on the default settings, but the lessons I am taking require MySQL 8.0 or higher. I am using Wampserver 3.0.6 (64-bit) on Windows 10.