As I can see, You are using latest XAMPP. All you need to do is, after opening MySQL Workbench, and instead of setting up a new connection, Press CTRL+R or click on DATABASE tab in the top menu. Select Reverse Engineer and provide necessary information. You are good to go now. The MySql workbench wont … Read more
To export: mysqldump -u mysql_user -p DATABASE_NAME > backup.sql To import: mysqldump -u mysql_user -p DATABASE_NAME < backup.sql
Just answering my own question. I found the feature by accident. It was moved and renamed to and is now located here: Edit > Format > Beautify Query Shortcut: Ctrl+B
I think OP was asking about charset that Workbench uses in its editor and how to setup Workbench to use UTF-8 in GUI – not how to setup default charset used for database table in Workbench. At the moment in Workbench one can set database table charset but regardless of it Workbench will in it’s … Read more
This is likely because you have named at least one constraint with the same identifier as a column: /* You already have a column named `restaurant` in this table, but are naming the FK CONSTRAINT `restaurant` also… */ CONSTRAINT `restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO … Read more
If you just want to do a single table through the MySQL Workbench. In MySQL Workbench: Connect to a MySQL Server Expand a Database Right Click on a table Select Copy To Clipboard Select Create Statement A create statement for the table will be copied to your clipboard similar to the below: CREATE TABLE `cache` … Read more
It’s not a bug but a feature since JMeter 4: Workbench has been dropped from UI, you can now use Non Test Elements as immediate children of Test Plan. You can now use elements in Test Plan as you used previously in Workbench You can see also an old question that asked why workbench is … Read more
In the Alter Table dialog of MySQL Workbench: Go to Indexes tab. Double-click on a blank row to create a new index. Choose ‘UNIQUE’ as the index type. Check the columns that you want to be unique together. There’s some discussion as to whether this is weird, since an index is not the same as … Read more
D’oh. I realise the problem was just that the Output Area was not visible on my WorkBench screen. For some reason when I first loaded it, the Output area was condensed down to just a heading, with no room to see the lines describing the result of each statement, and error codes when applicable. One … Read more
Good News! 😃 Apparently this is a widespread bug on macOS High Sierra that was fixed in version 6.3.10 that was released Nov. 15th 2017. They fixed it as described in the release notes: https://dev.mysql.com/doc/relnotes/workbench/en/wb-news-6-3-10.html Executing a query in MySQL Workbench on a host running macOS High Sierra failed to load the result grid completely, … Read more