MySQL Examples

Examples for exporting data from MySQL databases.

Single-threaded Export

Simple export without parallelization.

.\\FastTransfer.exe `
  --connectiontype "mysql" `
  --server "localhost" `
  --port "3306" `
  --database "test" `
  --user "root" `
  --password "password" `
  --query "SELECT * FROM test_table LIMIT 1000" `
  --directory "C:\temp" `
  --fileoutput "mysql_test.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

Parallel Export - Random Method

Export using Random distribution.

.\\FastTransfer.exe `
  --connectiontype "mysql" `
  --server "localhost" `
  --port "3306" `
  --database "test" `
  --user "root" `
  --password "password" `
  --sourceschema "test" `
  --sourcetable "orders" `
  --directory "C:\temp" `
  --fileoutput "mysql_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "order_id" `
  --paralleldegree 8 `
  --merge "False" `
  --runid "mysql_to_csv_parallel8_random"

Parallel Export - DataDriven Method

Export using DataDriven distribution based on distinct column values.

.\\FastTransfer.exe `
  --connectiontype "mysql" `
  --server "localhost" `
  --port "3306" `
  --database "test" `
  --user "root" `
  --password "password" `
  --sourceschema "test" `
  --sourcetable "orders" `
  --directory "C:\temp" `
  --fileoutput "mysql_orders_dd.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "DataDriven" `
  --distributekeycolumn "status" `
  --paralleldegree 10 `
  --merge "False" `
  --runid "mysql_to_csv_parallel10_datadriven"

Export to Parquet

Export MySQL data to Parquet format.

.\\FastTransfer.exe `
  --connectiontype "mysql" `
  --server "localhost" `
  --port "3306" `
  --database "test" `
  --user "root" `
  --password "password" `
  --sourceschema "test" `
  --sourcetable "orders" `
  --directory "C:\temp" `
  --fileoutput "mysql_orders.parquet" `
  --parallelmethod "Random" `
  --distributekeycolumn "order_id" `
  --paralleldegree 6 `
  --merge "False"

tip

Build your command with the Wizard