MySQL LOAD_FILE() loads null values

by

I copied my file to the location where MySQL has access to.
To know the location I used:

select @@secure_file_priv;

and it gave me /var/lib/mysql-files/.

Nothing else worked: neither turning off apparmor, nor changing ownership and permissions, nor merely granting the file privilege. So I rolled back most of that but the right directory still works. In my case.

My source is Raymond Nijland, here: https://dba.stackexchange.com/questions/190380/load-file-producing-null

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Convert timestamp to date in MySQL query
  12. Update a column value, replacing part of a string
  13. Parse date in MySQL
  14. mysql dynamic query in stored procedure
  15. mysql: get record count between two date-time
  16. Table is ‘read only’
  17. How to select one row randomly taking into account a weight?
  18. auto_increment by group
  19. Composite key as foreign key (sql)
  20. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  21. MySQL export into outfile : CSV escaping chars
  22. Simple Random Samples from a MySQL Sql database
  23. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  24. MySQL Select minimum/maximum among two (or more) given values
  25. group by range in mysql
  26. MySQL update statement to store ranking positions
  27. Display all tables. Describe-like functionality
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment