<div>
If you connect to the server administration part of workbench there is a data export / restore navigation item.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/02_w07/897483/ee1.PNG" target="_blank" title="ee1.PNG (3 KB)"><img alt="ee1.PNG" class="file-block lazyload" style="max-width: 186px;" data-src="https://filedb.experts-exchange.com/incoming/2015/02_w07/897483/ee1.PNG" /></a>
</div>


If you connect to the server administration part of workbench there is a data export / restore navigation item.

ee1.PNGhttps://filedb.experts-exchange.com/incoming/2015/02_w07/897483/ee1.PNG

ee1.PNG

<div>
when I choose data export, why is this only giving me structure and no data? Am &nbsp;I missing something in the settings?<a href="https://filedb.experts-exchange.com/incoming/2015/02_w07/897490/Untitled-1.jpg" target="_blank" title="screenshot (6 KB)"><img alt="screenshot" class="file-block lazyload" style="max-width: 250px;" data-src="https://filedb.experts-exchange.com/incoming/2015/02_w07/897490/Untitled-1.jpg" /></a>
</div>


when I choose data export, why is this only giving me structure and no data? Am  I missing something in the settings?screenshothttps://filedb.experts-exchange.com/incoming/2015/02_w07/897490/Untitled-1.jpg

Untitled-1.jpg

<div>
<div class="content wysiwyg-content">
Is there a simple way to get an export of all mysql tables and the data from mysql workbench.<br />
I used the export feature, and I didn't realize I was only getting table structure.<br />
How can I get all the data in the export file as well?
</div>
</div>


Is there a simple way to get an export of all mysql tables and the data from mysql workbench.
I used the export feature, and I didn't realize I was only getting table structure.
How can I get all the data in the export file as well?

backup in mysql workbench

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.