Data export from Amazon RDS MySQL instance

July 16th, 2020

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for back up, etc. The fact that data are usually required yesterday and export tasks need to be repeated again and again only compounds the difficulty. This article presents a walkthrough on how to export data quickly and easily with the help of dbForge Studio for MySQL.

Data Export and Import Tools for MySQL

Data export and import utilities of dbForge Studio for MySQL are long time favorites of database administrators as they allow getting export/import jobs done with a little as a few clicks of the mouse. And the cherry on the cake is a comprehensive and easy-to-follow user interface letting non-expert users successfully perform data migrations.

Export MySQL data from AWS RDS

In this worked example, we will export data from the Customer table on Amazon RDS to an MS Excel file. Please note, that with dbForge Studio for MySQL it is also possible to export the result of the query. To export the query result, call the Data Export wizard by right-clicking the result grid and follow the instructions.

Step 1: Establish a connection

To start working with the Export tool of dbForge Studio for MySQL, we need to establish a connection to the database on Amazon RDS. To add a new connection navigate Database -> New connection. In the Database Connection Properties window, make all the necessary connection settings.

AWS RDS export MySQL database data - establish a connection

Step 2: Open Data Export wizard

To export data from Amazon RDS to a file, first, you need to call the Data Export wizard. This can be done from the Data Pump tab on the Start Page. Alternatively, in the Database Explorer, right-click a table you want to export data from and select the Export Data command from the context menu that appears.

Step 3: Select file format

In the Data Export wizard, select an export format and click Next. In this tutorial, we will export MySQL data from Amazon RDS to one of the most common formats – MS Excel 2007.

Amazon RDS export database data - select file format

Step 4: Select a source table

On the Source tab of the Data Export wizard, select a table you want to export data from and click Next.

AWS RDS export MySQL database data - select a source table

Step 5: Set output options for the data to be exported

The Output settings tab provides the possibility to set export options for the output file.

Export AWS RDS database data - set output options

Step 6: Set table grid options for the data to be exported

On the Options tab of the Data Export wizard, you can configure the table grid layout for the exported data. You can configure the following:
– Borders style and color
– Header text color, font, and background
– Text color, font, and background for even and odd rows separately.

You can preview the result and change the settings if required.

Step 7: Select columns for export and adjust data formats

On the Data formats tab, you can select columns for export and adjust data formats. It is possible to exclude certain columns from export, change column names and their types of data.

Export AWS RDS database data - select columns

Step 8: Set page print options

On the Page print options tab, you can select the page size, specify the orientation and margins, add Footer and Header text.

AWS RDS export MySQL database data - page print options

Step 9: Select the rows to be exported

On the Exported rows tab of the Data Export wizard, you can select the range of rows to be exported. You can choose to:
– Export all rows
– Export selected rows
– Export a range of rows and specify it.

Export AWS RDS database data - select range of columns

Step 10: Specify errors processing behavior and logging options

At last, on the Errors handling tab, you can configure the application behavior in case it encounters an error. Here you can also tune the logging options.

AWS RDS export MySQL database data - errors handling options

Step 11: Finish export and save the template

Having completed all the steps in the wizard, click the Export button. You will see a notification about the result of your export job. The undoubted advantage of dbForge Studio for MySQL is the ability to save the export configurations for recurring export tasks. Click the Save button to save the settings either as an export template or as a batch file for further command-line operations.

Export AWS RDS database data - finish export

Step 12: Check the result

Click the Open result file button to check the result.

AWS RDS export MySQL database data - check the result

Note:

You can then use the file to transfer data to another MySQL database either local or remote. To learn how to import data from a file using dbForge Studio for MySQL, please see the tutorial.

Conclusion

dbForge Studio for MySQL allows exporting data from Amazon RDS quickly and easily. You don’t need to suffer configuring the Export wizard again and again – just save the export template and perform your export jobs in a wink. Have a need in scheduling or automating export tasks? It’s not an issue either, save the export options as a batch file and schedule it with Windows Task Scheduler.

Try the Studio out and all your doubts if any will fall away!

Leave a Comment