MySQL Dump to Document

Overview

Used to backup a subset of tables in an automated fashion. This is an updated version that uses modernized Appian APIs for document writes, and fixes an issue with interfacing with MariaDB using a JDBC driver >= 3.0 and removes deprecated smart services.

Key Features & Functionality

* IMPORTANT NOTE * MySQLDumpToAppianDocV2 has been removed from this version, so implementing this plugin will require updating existing processes!

Smart Services: MySQLDumpToAppianDocV3

Smart service taking in a DB name, and table prefix for exporting the table create, inserts, and optionally views into a SQL Document file.

Inputs Parameters:

• Database name (text) - Database name to export
• Table Names Start With (text list) - List of prefixes to export
• Include Views (boolean) - Toggle whether or not to include views in export
• Document to overwrite (document) - Document to overwrite with the new export.
• New Document Name (text) - Text for the new .sql document to be created.
• Destination Folder (Folder) - Folder where new document should be placed.
• Fetch Buffer Row Count (Integer) - Optional parameter to override default fetch buffer, use for performance tuning as needed, to balance memory consumption and execution speed.
• Lock Tables (boolean) - Toggle whether to lock tables for export or not.

Outputs Parameters:

• Generated Dump Document (Document) - Document that was generated or updated by this smart service