You can't use this until you register with us!

Description

Read data from one MySQL database and load it into another MySQL database.

Purchasing Options

MySQL to MySQL Loader - $0.0 / month

Available Actions

Run SQL Query with Date Parameters

Execute an SQL Query on a datetime bounded range of data in a MySQL database and store the results in a table in another MySQL database.

Variables

Source Parameters
source_db required

Select the MySQL database where the query will be executed to find data to load.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

destination_primary_key

Specify the name of the primary key column. Column name must exist in the SELECT statement of the SQL Query and in the Destination Table.


Destination Parameters
destination_db required

Select the MySQL database where the result data will be stored.

destination_table_name required

Specify the name of the table, in schema.table format, where the result data will be stored. If the table does not exist, it will be created.

allow_overwrite required

If enabled, existing entries in the destination table with the same primary keys will be overwritten.


Range
range_start_point required

Datetime stamp where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point_query

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Run SQL Query with Integer Parameters

Execute an SQL Query on an integer bounded range of data in a MySQL database and store the results in a table in another MySQL database.

Variables

Source Parameters
source_db required

Select the MySQL database where the query will be executed to find data to load.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

destination_primary_key

Specify the name of the primary key column. Column name must exist in the SELECT statement of the SQL Query and in the Destination Table.


Destination Parameters
destination_db required

Select the MySQL database where the result data will be stored.

destination_table_name required

Specify the name of the table, in schema.table format, where the result data will be stored. If the table does not exist, it will be created.

allow_overwrite required

If enabled, existing entries in the destination table with the same primary keys will be overwritten.


Range
range_start_point required

Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.