MySQL is one of the the world’s most popular open-source relational database management system. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database.
The data in a View in Mammoth can be exported to the MySQL database on a remote server.
Open Data Preparation > Exports > MySQL.
Enter your database credentials - Host, Username, Password, Database, and the Table name.
Check the checkbox “Keep at the end of the pipeline” to keep the export task at the end of your pipeline. Any task performed will be added to the Pipeline before the export task.
Enable the checkbox “include hidden columns” if you want the hidden columns to be exported.
Validate the credentials. Once it is validated, click on “Apply”.
A table with data from the View will be created in the remote database.
Except table name, the other requirements are mandatory. If table name is not provided, it will be auto-generated and visible in the notification corresponding to the action.
If a table is present in the database with same name as table name mentioned in the export action, then the existing table would be deleted and a new table will get created with that name.
Make sure you have the write access to the database.