As outlined by a previous answer, but just to clarify further: This is for MySQL in Windows.
I was having the exact same issue while trying to dump data out of a table on a local test server, and based on the previous answer, this is how I did it.
- Find your mysql original download folder, and look in the
/binfolder, there should be amysqldump.exe. - Go into Workbench Preferences:
Edit -> Preferences -> Administrator -> Pathto mysqldump Tool, and enter in the path to the mysqldump.exe that you found. - Save by pressing “OK” and restarting Workbench.
- Open up terminal, but typing in
cmdin the Search area of the start menu (Windows 7), and find the sql folder you found in step 1, and cd into bin. It should look likeC:\...\bin>. Here, type inmysqldump -t -u [username] -p [database name] [tablename]. This should dump the data from the[tablename]table into the dump folder as designated in Workbench.
Hope this helps!