mysql-workbench

What to do if Start Import option is not visible in MySQL?


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.

I'm not able to see the "Start Import" option.

I have hidden my taskbar and I have pointed to  the button which I'm looking for.


Solution

  • 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.