Hi Team,
What is the best practice in doing a backup data from all tables in Appian? If using stored proc, how the data will be dump or be made to .sql backup?
Any other options available on this?
Regards
Discussion posts and replies are publicly visible
I recommend using the MySQL Dump to Document shared component. You can configure a process model to call this plugin's smart service and target the tables and data you want to export to a SQL file.
Is there any way to back up the whole table of MySql using MySQL Dump to Document. When I did try it, I received this error message.
What I set up is as follows:
Batch Size: 1000
Document Name: date and time
Dump Table Prefixes: ={""} - Indicated on the shared component to export all
Folder: My folder path
Jndi Name: My appian JNDI
Hi Coltonb,
Sorry getting back slowly.
Been trying the SQL Dump to Document again and encounter this problem. Managed this to work on our instance but when imported to a different environment I encounter this error.
Appreciate your help!
John
MySQLDumpToDocument.txt
Hi coltonb, tried your suggestion but found nothing along with the error of the plugin. I might just missed it, so attached is the logs. Please take a look.