I have database in MySQL for an application which basically generates some kind of numbers with some other info attached with each number and the current size of the database is 1.5 TB . Now I want to migrate that DB to another server which have MySQL 8.0.25 and older MySQL version is 5.6.
both servers are on same network so I can easily copy files, so I tried with copying the DB files but that didn't work. Reason might be any major release was missing in between.
Due to DB size its not possible to generate script and then load the DB into new through script.