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.
P粉2177845862023-09-13 22:01:57
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.