MySQL is one of a popular, open-source relational database management system. SQL is used by programmers to create, modify and extract data from a relational database and control user access to a database.
It is possible to export the data in a View in Mammoth to a MySQL database on a remote server:
Open Data Preparation > Exports > MySQL;
Enter your database credentials - Host, Username, Password, Database and the Table name;
Tick 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;
Tick the checkbox “include hidden columns” to export the hidden columns;
Validate the credentials;
Once validated, click on “Apply.”
A table with data from the View will then be created in the remote database.
Apart from the table name, all other requirements are mandatory. If a table name is not provided, it will be auto-generated and visible in the notification corresponding to the task;
If a table is present in the database with the same name as the table name mentioned in the export task, the existing table will be deleted and a new table will be created with that name;
Ensure you have the write access to the database.