Hi Folks,
I am trying to import around 15mb of data (via a .sql file) in maria db through the import functionality; but it's not allowing and showing error message as shown below. Anyone knows what the alternative for this is as we are gonna import gb of data from the legacy system to appian as part of data migration.
What is the max size that Appian maria db allows?
Regards,
Ghanashyam
Discussion posts and replies are publicly visible
hi ghanashyamm0005 AFAIK, the maximum packet for MariaDB is 16 MB. could try uploading in chunks?
To perform such a huge migration, I suggest to talk to Appian for support.
Max allowed file size is mentioned in the Import screen. Please see the below screenshot for reference:
Hi Yogi,
In my previous project, we used the Import SQL file Smart service to push this data into our Maria DB. I am not sure how they wrote this plugin but it will execute faster. We dump nearly 2GB of data by using this plugin.
Note: We cannot upload the 2GB document directly in Appian. To overcome we uploaded the document in ZIP Format.