One of the most common activities when working with MySQL is exporting and importing data, this article focuses on that while using DreamCoder for MySQL.

The DreamCoder for MySQL has several mechanisms that facilitate the process of exporting data which are detailed below:

Export Manager: This option facilitates the complete or partial exportation of database in SQL format. This option is very practical since you can export scripts and other data at the speed of light.

Export Data: This option is available in the table view and the SQL editor, and it allows us to export data from grids whether it is a consultation result. With this option we can export the data in 14 well known formats, which are, excel, word, html, access, pdf, xml, txt, csv among others. It also includes special export options within each format.

Advanced grid options: On this menu we find several options that facilitate direct exportation of data to MS Excel or to the clipboard.

Possible options:
1. Copy all records to clipboard
2. Copy selected grid
3. Copy rows to grid

You can copy all the data or a group directly to excel or a clipboard. Also, there are four more options called "export custom grid" which allows us to export grid data, which includes data of groups and operations you are currently working on.

These export options are available on the commercial version of DreamCoder for MySQL.

1. DreamCoder for MySQL Ver 4.3 available for download
2. DreamCoder for MySQL version 4.4 released
3. DreamCoder for MySQL Beta Program
4. New minor update of DreamCoder for MySQL version 4.4.2.5 is available for download