• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

backup in mysql workbench

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?
0
rivkamak
Asked:
rivkamak
  • 2
1 Solution
 
rjohnsonjrCommented:
If you connect to the server administration part of workbench there is a data export / restore navigation item.

ee1.PNG
0
 
rivkamakAuthor Commented:
when I choose data export, why is this only giving me structure and no data? Am  I missing something in the settings?screenshot
0
 
rjohnsonjrCommented:
The last checkbox says skip table data and you have it checked
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now