Upgrading MySQL Server 3.51 to 8.0 from 2001 using WinMySQL

Question

Our company has a live MySQL server where everything is centralized. It was created around 1998 and has been running continuously ever since.

MySQL version is 3.51. WinMySQL 2001 version 1.4.

I was just born then...

I need a secure way to migrate the data to a newer version as I cannot access this database using any current software.

mysqld-max-nt.exe is the name of the service.

Only the 2001 version of WinMySQLAdmin still works. I did find a way to create a database dump at some point, but no version of MySQL can read it.

I need a way to upgrade to MySQL 8.0 without losing data.

Answer 1

My suggestion is to export the data to excel or csv or txt format instead of sql format, because mysql 3 is too old and a lot of data types have changed, that's why the current version cannot read this file format. Then create a new table (new data type) in mysql and import the data.