0

Hi,

I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding other tools but I couldn't find anything...

Any help would be appreciated...

Thanks,
Ashton.

6
Contributors
11
Replies
23
Views
6 Years
Discussion Span
Last Post by sergeik.rndwork
0

Hi,

Does anyone know of a GUI that has functions to generate INSERT statements based on the table data?

mysqldump is quite confusing...

Thanks,
Ashton.

0

as has heidiSQL and SQL manager lite from ems. In fact almost every database management application that I've used has it.

0

Ya so I've noticed, but on MySQL Workbench, when I forward engineer and select "Generate INSERT statements" - it doesn't do it for some weird reason, so I was hoping I'd get a decent alternative that works for sure

0

Here is a list of MySQL GUIs, all of them offer data export option.

Ya so I've noticed, but on MySQL Workbench, when I forward engineer and select "Generate INSERT statements" - it doesn't do it for some weird reason

Does it display any error? Does it generate empty file?

0

Hi,

Ya it just creates the .sql file with the code to create the empty schema basically... Well, I reverted to the legacy MySQL GUI and did it with MySQL Administrator Tool and it worked really well!

Either the new Workbench sucks, or Windows 7 sucks... or they both suck...

But ya, the legacy GUI's work way better for me...

Thanks,
Ashton.

0

I have never used Workbench, there might be an option to include/exclude the table data export.

0

ya there is one, but it doesn't work... its like the front end is there but theres no back end attached to it... I dunno... but the important thing is that I got it to work, so ya... I'm grateful for all your help

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.