Loading large amount of data into table

MySQL
1

Hi, I created a MySQL database on Aiven (using a free plan) and now I’m migrating the table data.
I’m currently using the Table Data Import Wizard on MySQL Workbench, but it’s an extremely slow process.
I would like to use the “load data local infile” method but I got the “Error Code: 3948. Loading local data is disabled; this must be enabled on both the client and server sides” error.
I tried to “SET GLOBAL local_infile=1;” but I got the “Error Code: 1227. Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation” error.

Is there a way to use “load data local infile” ? Are there other methods to import large data to MySQL DB on Aiven ?

Thanks
Gabriele

2

Hey Gabriele,

I’m no expert on this specific topic, but perhaps the following link(s) may be helpful:

All the best!

Kevin