Exporting Data through Command Line

You can automate data export process using command line. Such possibility can be very useful if you need to export data from the same table or view quite often (for example, such data may be needed for generating a report, etc.). In this case you can create a template file using Data Export Wizard, where all export settings will be saved, and perform export by specifying the name of this file in the command line instead of going through all wizard pages. Note that some parameters like connection, destination file, and some others can be specified directly in the command line. In this case values of these parameters specified in your template file will be overridden.

To create a template file:

  1. On the Database menu, click Export Data to open Data Export Wizard.
  2. Go through all wizard pages and specify necessary information and settings.
  3. When all necessary settings were made, click Save Template on any of the wizard’s pages.

Note

The generated file does not contain password information for security purposes. If the Save Password option is checked for the selected connection in dbForge Studio for MySQL, you should not do anything regarding the password. If it is not, then you should define the password with the help of the /password option.

Note

It is not necessary to click Export in the wizard and perform the export process itself to create a template file.

To export data through the command line:

  1. Click Start.

  2. Type cmd in the Search programs and files text box and press the ENTER button.

    Note

    To run the Command Line in Windows 8:

    From the Desktop Mode

    • Move the mouse cursor to the exact lower left corner until the desktop shortcut menu appears.
    • Right-click to see the shortcut menu and then click Run.

    From the Charms Bar

    • Move your mouse to the upper right corner until Charms Bar appears.
    • Select Apps from the list and type run in the search box.
    • Click Run from the search results.

    Use Windows + R Shortcut Keys

    In a desktop mode, press Windows+R to show the Run command line.

  3. Type a path to the dbforgemysql.com file located in dbForge Studio for MySQL installation folder on your PC, and press the SPACE key:
~~~
C:\Users\user>C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com
~~~

Note

It is not necessary to specify the extension of the dbforgemysql.com file.

  1. Specify the operation you want to perform (data export) and the template file:

     /dataexport /templatefile: filepath
  2. Type all other arguments you need.
  3. To run the process, press ENTER.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?
Download a free 30-day trial