As you can see in the below picture, I'm not able to see the "Start Import" option. Can anyone help me with this? And if you see in the second picture where I have hidden my taskbar and I have pointed to the button which I'm looking for. So how can I get that button on the main screen as we can't scroll in the "Data Import" window.
Check if you have an exported file that has only data or both structure and data.
If your exported file only contains data, then check If you exported the database only contains data, then you have to create all the tables inside your new database.
In MySQL Workbench, we can easily export with both Structure and Data.
you can use the PowerShell to import the database instead of mysql workbench,
all you need to do is locate the mysql.exe file on your system, for me its on
C:\wamp64\bin\mysql\mysql5.7.26\bin
so the command would be like this for importation on windows:
C:\wamp64\bin\mysql\mysql5.7.26\bin\mysql.exe -u [db_user] -p[password] -h 127.0.0.1 [db_name] < backup-file.sql
on Linux:
mysql -u [db_user] -p[password] -h 127.0.0.1 [db_name] < backup-file.sql