This seems to be a useful tool to convert mysql or oracle schema to redshift. select queries can also be migrated easily using...

http://www.sqlines.com/online

Steps to install innobackupex on Ubuntu:

$ apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Add this to /etc/apt/sources.list, replacing VERSION precise with the name of your distribution:

deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main

Remember to update the local cache:
$ apt-get update

Now you can install Percona XtraBackup with:
$ apt-get install percona-xtrabackup

# Here are the 2 steps to start tokudb
cd /root/percona-5.5.30-tokudb-7.0.1-fedora-x86_64/
./bin/mysqld_safe &

# start proxy with failed query log
sh /usr/share/mysql/mysql-proxy-0.8.3-linux-rhel5-x86-64bit/bin/mysql-proxy --plugins=proxy --proxy-lua-script=/usr/share/mysql/mysql-proxy-0.8.3-linux-rhel5-x86-64bit/share/doc/mysql-proxy/failed-query.lua

$ # As of March 2009, the latest version was 3.6.11.
$ wget http://www.sqlite.org/sqlite-amalgamation-3.6.11.tar.gz
$ tar xzf sqlite-amalgamation-3.6.11.tar.gz
$ cd sqlite-3.6.11
$ ./configure && make
$ sudo make install

When there is maintenance work to be carried on the database server, you can simply skip networking so that no connection from any other server from the network will be accepted.
Simply enter the following in /etc/my.cnf:

[mysqld]
# Prevent network access to MySQL.
skip-networking

sqlite> .mode list
sqlite> .separator |
sqlite> .output test_file_1.txt
sqlite> select * from tbl1;
sqlite> .exit
$ cat test_file_1.txt
hello|10
goodbye|20
$

When you have your mysql up and running, just connect to any database (like mysql or test) and perform a following command:

CREATE TABLE innodb_table_monitor(x int) engine=innodb;

This will force innodb engine to start table monitor and dump some useful data regarding your tablespaces in mysql's error log

mysql -e"SELECT CONCAT('OPTIMIZE TABLES ', GROUP_CONCAT(TABLE_SCHEMA, '.', TABLE_NAME ORDER BY TABLE_SCHEMA, TABLE_NAME SEPARATOR ',')) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' GROUP BY TABLE_SCHEMA\G
" | awk -F: '{print $2}' | mysql