SQL Statements for Creating Tables

You will need initially to create the tables on Amazon Redshift that will be replicated. To make it easier, you can generate an SQL dump file which can be used to create these tables on Amazon Redshift. To do this, from the server in which you installed the FlyData Agent, execute the following from the command-line:

$ flydata sync:generate_table_ddl > create_table.sql

This will retrieve the MySQL table definitions and generate CREATE TABLEstatements which can then be used to create the same tables on Amazon Redshift. It won’t contain the data; that comes later. You need to prepare the tables first to receive the data. The results of this script with be a simple text file, a dump file that can be used to do that.