Since version 1.1.1, MySQL for Visual Studio has a database export too that creates a dump file for a MySQL database.
In order to open a new window for the MySQL Database Export tool, the user must create a new connection using the Server Explorer Window inside Visual Studio. Once the connection is established, a contextual menu can be opened by right clicking on the connection node. From the menu, choose the MySQL Database Export option. A new tabbed-window opens for the current connection. The user can select one or more databases to include in the dump.
Follow these steps to create a dump for the MySQL Databases:
Select all the databases and their objects to be included in the dump.
It is very important to select the desired settings for the dump: whether the dump will include the data, whether the insert operations will be logged in extended mode, and so on. In the main window of the MySQL Database Export tool are shown the basic options for the dump. Also, by clicking on the Advanced button, more specific options can also be selected.
When the selection of the options is done, give a name to
the result file that will be created. If no path is given
for the result file, the default path to be used is
My Documents under the user's folder.
A filter can be applied on the list of schemas for the selected connection. With it, the user can easily locate the databases to be included in the dump.
After selecting the options and the name for the dump file, the user can click the Export button, which generates the dump.
Each dump can have different settings. Once the user has selected
the settings to be used for the dump operation, these settings can
be saved into a setting file for later use. This file includes:
the connection selected, the name of the file for the dump, and
the database or databases and the objects selected for dumping.
The file extension for the setting file is
A saved setting file can be loaded into the MySQL Database Export tool by clicking the Load Settings button.
Copyright © 2004, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices