Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I export tabluar data using Mysql WorkBench 5.2.37 CE Rev 8576? It seems I can export table schemas no problem but the .sql file generated has no data whatsoever?

Steps taken:

  1. Established and Connected to Database
  2. Go To Manage Import / Export
  3. Go To Data Export
  4. Select Databases and Tables
  5. Export to Dump Project Folder
  6. Start Export

Is it that this program won't export data? Am I doing something wrong? Is it a bug?

share|improve this question
1  
via CLI: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql src0 src1 – jberger Sep 12 '13 at 10:30
up vote 4 down vote accepted

The export should be default include the table data. Make sure that Skip table data (no-data) in the options sub-panel is unchecked before you start the export.

If that doesn't work, try reverse engineering your database by going to the menu option Database > Reverse Engineer and complete the steps.

After you've reverse engineered your database, go to File > Export > Forward Engineer SQL CREATE Script.

Under SQL Options, check the box Generate INSERT statements for Tables and then continue the export process.

share|improve this answer
    
Yes that worked, I didn't see that option earlier lol... Is there a way to make this automatically reoccurring in the windows task manager like in the old MYSQL Administration software before Workbench? – Mallow Mar 2 '12 at 20:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .