Importing Data through Command Line

Last modified: October 18, 2023

You can automate data import process using command line. Such possibility can be very useful if you need to import data to the same table or view quite often. In this case you can create a template file using Data Import Wizard, where all import settings will be saved, and perform import by specifying the name of this file in the command line instead of going through all wizard pages. Note that some parameters like connection, input 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 Import Data to open the Data Import Wizard.
2. Go through all wizard pages and specify necessary information and settings.
3. When all necessary settings were made, click the Save Template button 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 the Import button in the wizard and perform the import process itself to create a template file.

To import data through command line:

1. To open Command Prompt, press Win+R and type cmd in the Open line.
2. 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

The path to the executable file will differ depending on how you have installed the Studio - as a standalone tool or as part of the dbForge Edge bundle. Make sure that you have specified a correct path. If you have installed the Studio as part of dbForge Edge, change the path accordingly:

C:\Program Files\Devart\dbForge Edge\dbForge Studio for MySQL>dbforgemysql.com