Digital Marketing

Load text data into AWS RDS MySQL serverless v2

If you encounter this while running "load data local infile"

(3948, 'Loading local data is disabled; this must be enabled on both the client and server sides')

For server parameter, it is enabled by default.
You can double check by running:

SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
So, you just need to enable it on client side:

mycli --local-infile=1 

Comments

Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership