• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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