Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Piter Jason: "I wanted to take this opportunity to thank SQL Maestro Group for providing me the tools to succeed. I have no doubt that without them I would have failed to do my job. I am proud that I have suceeded. Thank you".
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".


Add your opinion

Data Wizard for MySQL online help

Prev Return to chapter overview Next

Command line options

Data Wizard for MySQL supports a number of command line options that make it possible to fully automate the data management operations.


The Data Wizard for MySQL command line syntax is as follows:

mydatawizard[.exe] <task> <template_file_name> [<log_file_name>]



The Data Wizard for MySQL program file.


An operation to execute. It can be one of the following:

import (for Data Importing tasks);

export (for Data Exporting tasks);

sqldump (for SQL Dump tasks);

blobimport (for BLOB Import tasks);

blobexport (for BLOB Export tasks).


The template with all the task's settings.


The name of text file to store log information (optionally).



The examples below assume that you are entering the command lines in the Data Wizard for MySQL program directory.  Don't forget to enclose all paths and filenames containing spaces in quotes.

mydatawizard export "C:\Templates\Export\MySQL\northwind.extx" "C:\Logs\Export_to_MySQL_NBA_db.log"
pgdatawizard.exe import  "D:\Templates\Import\PostgreSQL\northwind.imtx"
mydatawizard.exe sqldump "C:\Templates\SQLDump\MySQL\sakila.sdmpx" "C:\Logs\SQLDump\MySQL\sakila.log"

Prev Return to chapter overview Next