Skip to main content
Known Participant
Jul 25, 2024 4:00 PM UTC
Question

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

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

4 replies

karumurua531442
Participating Frequently
Jul 25, 2024 4:11 PM UTC

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

stefanhelzle0001
Brainy
Jul 25, 2024 4:35 PM UTC

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

Brainy
Jul 26, 2024 6:01 AM UTC

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

cithar575376
Known Participant
Jul 26, 2024 7:09 AM UTC

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.