Question

What is the maximum data that can be imported to maria db from a .sql file

Forum|Forum|2 years ago
July 25, 2024
4 replies
1 view

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

karumurua531442

hi [mention:8a27d71badb7400d9bd8de772aa50e64:e9ed411860ed4f2ba0265705b8793d05] AFAIK, the maximum packet for MariaDB is 16 MB. could try uploading in chunks?

stefanhelzle0001

To perform such a huge migration, I suggest to talk to Appian for support.

Y

yogip3177

Max allowed file size is mentioned in the Import screen. Please see the below screenshot for reference:

cithar575376

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.

Sign up

Login with SSO

Login to the community

Login with SSO