Please refer below steps for migration database on MySQL 8.
0 server
1. Take structure only backup of a0258 from MySQL 5.6 server using below command
mysqldump -u root -p --no-data --routines --skip-triggers a0258 > /[Link]
(this backup contains tables & procedure without data)
2. Now install MySQL 5.7 on 111 server & create database a0258 on MySQL 5.7 server
3. Restore step no 1 backup on 121 server
4. Migrate step no 3 backup from 121 server into MySQL 5.7 of 111 server into
database a0258 using workbench
5. Again take backup of migrated database from MySQL 5.7
6. Now install MySQL 8.0.14 on E2E_MySQL8 server & create database a0258 on MySQL
8.0.14 server
7. Migrate MySQL 5.7 from 111 server into MySQL 8.0.14 on E2E_MySQL8 server using
workbench into database a0258
8. Now our structure is migrated into MySQL 8.0.14
9. Take a full backup of migrated database from MySQL 8.0.14 and create new
database scriptdb on E2E_MySQL8 server
and restore this backup into MySQL 8.0.14
10. Now we have to restore data only backup of a0258(e2e server) into our MySQL
8.0.14 server (a0258 db)
For taking backup use below command
-- e2e server
mysqldump -u root -p --no-create-info --complete-insert --skip-triggers a0258 > d:\
a0258_data_only.sql
-- restore into MySQL 8.0
mysql -u root -p -h [Link] a0258 < d:\a0258_data_only.sql
