1 person found this helpful
While at first glace a simple dump of the data and reload seems in order. But 5.6 lacks certain things like microsecond support. If you check through your data and find INT, CHAR/VARCHAR, DECIMAL only data columns you could probably get away with a simple dump. However at the first sighting of a time stamp I would either write an app to read from the 5.6 instance and write to the 8.0 instance OR prepare to do the 5.6 to 5.7/5.7 to 8.0 upgeade.
Thanks for the information Dave. We'll take it into account. Fortunately, there is only 10 -12 tables and a limited amount of data in our circumstance.
I did figure out that there is a fairly intuitive GUI tool (Data Export / Data Import ) to do the exporting/importing from the Workbench.