How to Migrate from SQLite DB to MySQL?

I need to migrate my Database in Amazon Redshift to MySQL DB. What are the steps I need to follow? The DB has around 200 tables

• Answer:

  Well, I dont think that's a very nice problem to have. Redshift is an MPP columnar database, while MySQL is a traditional row-store RDBMS. There are a lot of thing which are implemented differently in these two database systems. For instance, your tables in Redshift must be having distribution styles, compression schemes etc. You will not find any equivalent things in MySQL. Redshift has a concept of schema within the same database( just like Microsoft SQL Server), while MySQL follows a more Oracle-like methodology where you can have different schema within the same instance (and not within the same database). So, if you have your tables in Redshift with different schema withing the same database, you will have to rethink how you want to implement those tables in MySQL. Solutions: If you just have to do it, I would suggest to use Aginity workbench and extract the scripts for DDLs and DMLs for your Redshift tables, then apply the changes which are incompatible with MySQL manually. Another approach can to be use Unload command to push data into CSV files and then move them to MySQL. But unload command might give multiple files for each table based on the amount of data in the table, so you might face some problems in importing them back into MySQL.