You can replicate MySQL data to a target by using the replication task. You might replicate data to back up the data or perform offline reporting. You can replicate data in MySQL objects to databases or flat files.
A replication task can replicate data from one or more MySQL objects. When you configure the task, you can replicate all available objects through the selected connection, or you can select objects for replication by including or excluding a set of objects.
You can also exclude rows and columns from the replication task. Associate a schedule with a replication task to specify when and how often the task runs.
Note: The length of source tables and column names can contain at most 128 characters.