Want to batch transfer data from Redshift tables to MySQL ?
Using Withdata software DB Copier, a Redshift to MySQL converter for Windows, MacOS, and Linux, you can transfer data from Redshift tables to MySQL (MariaDB, Percona) in a batch, easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
Batch transfer data from Redshift tables to MySQL (MariaDB, Percona) tables
Login to Redshift and MySQL -> Select source Redshift tables -> Set target MySQL tables -> Copy Redshift data to MySQL
Choose source Redshift database and logon.
Choose target MySQL database and logon.
Click “Convert All Tables” at task dialog.
then show the wizard.
1. Select source Redshift tables.
2. List target MySQL tables.
3. Select MySQL tables to import.
4. Transfer data from Redshift tables to MySQL (MariaDB, Percona).
Batch transfer data from Redshift tables to MySQL in command line
Save “Redshift tables to MySQL” session, then you can:
- Batch transfer Redshift tables to MySQL in Windows command line.
- Batch transfer Redshift tables to MySQL in Linux command line.
- Batch transfer Redshift tables to MySQL in macOS command line.
Set scheduled tasks for coping data from Redshift tables to MySQL
You can schedule and automate this “Redshift to MySQL” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.