For the latest tutorials, visit our new self-service portal. Sharpen your skills and explore new ways to use Octoparse.

This guide will teach you how to export data to your MySQL database manually and automatically. It will also introduce Octoparse's auto-export tool for databases.

Here are the prerequisites before we start:

• Tasks with data results (Auto-export to the database is for Cloud data only)
• A table with data fields configured in your database to receive data 

1. How to connect to your database

This tutorial will use the MySql database as an example.

View the Cloud data for the target task.

• Click the "Export Data" button
• Open "Export to Database" or "Auto-export" to database
• Choose the type of your database
• Press "OK"

• Fill out the required fields for the target database settings.

After filling out the information, click "Test Connection" to see if you can connect to your database.

If the settings are alright, you will receive a "Connected" notice as above. Then, you can click "Next" to move forward.

We need to configure the data mappings now.

• Select an existing table from the Data Table drop-down options

• Match the source data fields (data fields extracted) to the target data fields from the designated table
• Select any source data fields to use as identifiers (primary key)

To export manually, you can go to the next step now. For the automatic export, you have to set up the schedule settings.

• Enter the name of the schedule into the text box next to "Scheduled Export"
• Select at what time interval you would like to export the data to the database, i.e. the export is scheduled to run every 1 hour in the screenshot.
• Click "Next" 

• After set-up is completed, press the "Completed" button to exit.

2. Introduction to database auto-export tool

After you set up the database settings, the Auto-export tool will pop up simultaneously. It will show you all the configuration details about auto-export to the database. You need to click "Start" to start the export. Octoparse will do the export at the interval you have set up after starting.

From the pop-up window, you can start/stop/delete the scheduled auto export to the database. You can also check the error report.

Please note that you have to keep the database auto-export tool open to keep exporting data. That means you cannot turn off your computer during the export. Otherwise, your data export will be stopped.