Re: Upgrade 5.1.47 myisam to 8.0

[Kurt Kavanaugh]

Thanks!

So the steps I took were. ( on a small data foot print we use for testing)

1. Installed MySQL 8.0 as a service
2. Opted for the 5.x authentication
3. created our database {foo}
4. stopped the service
5. stopped the legacy 5.1 service
6. copied the legacy files to C:\ProgramData\MySQL\MySQL Server 8.0\Data\Foo
7. started the server
8. BOOM. Everything seems to work.

I/we understand that this is not optimal, and we intend to move forward with the Connector/J 8.0 client and change our storage format to InnoDB (for a number of reasons).

But we are taking small steps and rolling out incremental updates.

So, in closing, are you saying if I copy over the 5.1.47 MYD and MYI files to the MySQL 8.0 data directory, the MySQL server will regenerate the FRM files on the fly and that we will get a reliable, if not optimal, outcome?