MySQL

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:

  1. Open Export and Share > Export to database > Already existing database > MySQL;

  2. Enter your database credentials - Host, Username, Password, Database and the Table name;

  3. 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;

  4. Tick the checkbox “include hidden columns” to export the hidden columns;

  5. Validate the credentials;

  6. Once validated, click on “Apply.”

    MySQL credentials

    Fig. 153 Enter MySQL credentials

A table with data from the View will then be created in the remote database. The export will also be recorded as a Task in the pipeline.

Note

  1. 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;

  2. 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;

  3. Ensure you have the write access to the database.